Improving Query Performance by using correct Search Arguments
In today’s blog posting I want to talk about a very specific performance problem related to indexing in SQL Server. The Problem Imagine the following simple query, which you have already seen hundreds of times in your SQL Server life: — Results in an Index Scan SELECT * FROM Sales.SalesOrderHeader WHERE YEAR(OrderDate) = 2005 AND …
Improving Query Performance by using correct Search Arguments + read more
