Last week I presented a session, Demystifying Statistics in SQL Server, at the PASS Community Summit, and I had a lot of great questions; so many that I’m creating multiple posts to answer them. This first post is dedicated to questions specific to creating statistics in SQL Server.
Q: Any book recommendations that teach most of this info?The online documentation, Statistics, is a good place to start.You can download, for free, a PDF version of Inside the SQL Server Query Optimizer by Benjamin Nevarez, which includes information specific to statistics. It is from 2010, but some information remains relevant.Q: If