Have you been updating statistics as part of your maintenance plan, even though you’re not really sure what they are? Have you been asking yourself where statistics exist, how to find them, and what people mean when they say “check statistics”? Do you look at the database options for statistics and wonder if they really matter? It’s time to end the guessing and start understanding the basics about statistics. In this session I’ll answer these questions using straight-forward demos and real-world examples. And if you haven’t been updating statistics as part of your maintenance plan don’t worry, I’ll get you started.
Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 12 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery.
Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.