SQLServerPedia

 

I thought I had pretty good understanding of SQL Server Statistics but wanted to explore and find out if there was something I missed out and didn't heard of. I did catch few extra points I didn't know of earlier and I am listing most of the links if any one are interested.

 

By Author: Eric N. Hanson and Contributor: Lubor Kollar

 

By Arun Marathe; Revised by Shu Scott

 

By Dan Cherry

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1278729,00.html

 

By Rob Carrol

http://blogs.technet.com/rob/archive/2008/05/16/sql-server-statistics.aspx

 

By Conor Cunningham

http://blogs.msdn.com/conor_cunningham_msft/archive/2008/07/24/statistics-sample-rates.aspx

 

Chris Skorlinski

http://blogs.msdn.com/chrissk/archive/2008/08/27/do-we-need-to-run-update-statistics-with-fullscan.aspx

 

Stefano

http://blogs.msdn.com/queryoptteam/archive/2006/07/21/674350.aspx

 

Kimberly Tripp

http://www.sqlskills.com/blogs/Kimberly/post/Auto-update-statistics-and-auto-create-statistics-should-you-leave-them-on-andor-turn-them-on.aspx

 

http://www.sql-server-performance.com/tips/update_statistics_p1.aspx

 

Kevin Kline

http://sqlblog.com/blogs/kevin_kline/archive/2008/05/19/why-isn-t-auto-update-statistics-running.aspx

 

Wesley B

http://sqlug.be/blogs/wesleyb/archive/2007/11/13/update-statistics-before-or-after-my-index-rebuild.aspx

 

Paul Randal

http://sqlskills.com/blogs/paul/post/Search-Engine-QA-10-Rebuilding-Indexes-and-Updating-Statistics.aspx

 

http://sqlserverpedia.com/wiki/Updating_Statistics

 

By Ian Jose

 

BOL Links

UPDATE STATISTICS

CREATE STATISTICS

DBCC SHOW_STATISTICS

STATS_DATE

sp_autostats

sp_updatestats 

sys.stats