Statistics

Useful statistics references…

The Basics

sys.stats

sys.indexes

sp_createstats

sp_updatestats

sp_helpstats

dbcc show_statistics

sp_helpindex – Kimberly L. Tripp

Statistical maintenance functionality (autostats) in SQL Server

 Statistics Used by the Query Optimizer in Microsoft SQL Server 2005

Statistics Used by the Query Optimizer in Microsoft SQL Server 2008

 

Statistics and Performance

Using Statistics to Improve Performance (MSDN)

 

Filtered Indexes/Statistics

Filtered Indexes – What You Need to Know (Michelle Ufford)

Filtered Indexes and Statistics Out of Date (Kimberly Tripp)

A Case of Using Filtered Indexes

Using Filtered Statistics With Partitioned Tables (SQLCAT)

 

The Kitchen Sink

How are auto created column statistics named (Paul Randal)