How SQL Server Index Statistics works - Part 2

This article demonstrates the real world examples of how SQL Server utilizes the index statistics.

Posted Under: Caching, Information, Performance, SQL Server 2005, Tuning
This post was written by namwar on July 31, 2008 Comments (0)

How SQL Server Index Statistics works - Part 1

This article describes the concept of index statistics in SQL Server and how it is used in query optimization.

Posted Under: Information, Performance, SQL Server 2005, Tuning
This post was written by namwar on July 17, 2008 Comments (2)

Selectivity of a Query and how it affects indexing

If you want to understand how selectivity of Query works then read this article.

Posted Under: Caching, Information, SQL Server 2005, Tuning
This post was written by namwar on July 12, 2008 Comments (1)