Want to learn more about managing statistics updates in SQL Server? Watch my 27 minute presentation on managing statistics.
You can also watch 12 minutes of audience Q&A on statistics from when I presented this on a live Hangout on Air. Questions include:
- Should I create single column statistics for non-leading key columns in an index?
- What is asynchronous statistics update?
- What are these statistics with “WA_sys” names?
- I have a bunch of user created statistics and it’s blocking a release. It is safe to drop them?
Got more questions on statistics? Check out my reference post on Updating Statistics in SQL Server, and ask away in the comments of the post!