Managing Statistics in SQL Server for DBAs (videos)

Want to learn more about managing statistics updates in SQL Server? Watch my free 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!

Previous Post
Updating Statistics in SQL Server: Maintenance Questions & Answers
Next Post
What’s the Difference between a Junior and Senior DBA?

Related Posts

5 Comments. Leave new

Your presentation is greatly appreciated.

Reply

Would it make sense to do a FULLSCAN and update stats every night?

Reply

Great presentation! The situation with the apparently auto generated stats showing up as user created can easily be caused by pushing changes using tools such as red gate. I have found (and done…oops) this may times myself.

Reply

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Menu