On the subject line the process to find the answer is not a short one! By design SQL Server engine takes care when the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the best indexes...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Sun, Nov 22 2009
Filed under: Filed under: sql server, performance, indexes, dmv, best practice, execution plan, monitoring, dbas, index hint, view server state