SQLBits 2022

Options for Proactively Managing Statistics in SQL Server

I often recommend that folks proactively manage statistics, but I always seem to run out of time to talk about HOW to do that...this session will cover exactly that.
Have you ever wondered how you could manage statistics beyond having AUTO_UPDATE_STATISTICS for your databases enabled, using a maintenance plan, and/or using the default options in Ola Hallengren's script? If so, this session is for you. I'll talk through the method I use to figure out what statistics need frequent updates, which ones have skew, and which ones aren't as critical. This session will move quick, so have some coffee before and be ready to keep pace!

Feedback Link - https://sqlb.it/?6967