12 July 2006 12:15
Simon's Software Stuff: SQL Server performance tips
by springnetDoes your SQL statement have a WHERE clause? I know this sounds obvious, but don't retrieve more data than you need. However, less obvious is that even if your SELECT statement retrieves the same quantity of data without a WHERE clause, it may run faster
SQL Server Database Performance Tuning And Other Articles
by springnet & 2 othersDoes your SQL statement have a WHERE clause? I know this sounds obvious, but don't retrieve more data than you need. However, less obvious is that even if your SELECT statement retrieves the same quantity of data without a WHERE clause, it may run fast
1
(2 marks)