12 July 2006 12:15
![](https://blogmarks.net/screenshots/2006/07/25/14c2bbf01831c67e45096a9e5f919bc2.png)
Simon's Software Stuff: SQL Server performance tips
![](https://blogmarks.net/img/default-gravatar.gif)
Does 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
1
(1 marks)