ok so I haven’t written anything about statistics yet on the blog, and Paul fielded a question from someone asking about details of the statistics implementation in SQL Server. Luckily, I know a little bit about that.
So, this post will cover the published background material that I think everyone should read about SQL Server’s statistics implementation, and then we can have a more detailed conversation about the nitty gritty fun details of them.
So this was written for SQL 2000 but the basic details apply to SQL Server 2005 and 2008. I’d read this first.
There was an additional white paper written for SQL Server 2005 that covers the new features that were added. Lots of extensions where we refined the features from 2000 and made them work more effectively.
If you have questions about statistics, feel free to post them up. If you wish to question statistics, then well I guess you should start with DBCC SHOW_STATISTICS.