Options for Proactively Managing Statistics in SQL Server

The January meeting for the Ohio North Database Training user group will be on Tuesday, January 4, 2021. This will be a virtual event and our featured speaker will be Erin Stellato.

5:00PM EDT: online meeting begins with a social hour. This is an unstructured hour where you can join us to catch up and meet other members of the group before the session starts.

6:00PM EDT: Updates and announcements, including open Q&A regarding officer positions and February elections (see https://ondt.org/?p=345 for a reminder). If you are interested in running for the UG board and have questions, please attend! This will be followed by Erin's session (please review the abstract below for more details).

We hope to see you there!

*Please note, we will be using Microsoft Teams for the meeting. You may want to join a few minutes early to ensure you do not have any issues.

Session Abstract:
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.

Speaker Bio:
Erin Stellato (she/her) is a Data Platform MVP and lives in Cleveland, OH. She has over 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, Query Store, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including SQLintersection, SQLBits, and the PASS Summit. Outside of time with family and friends, she enjoys running, reading, movies, and all things chocolate.

Blog: https://www.sqlskills.com/blogs/Erin
Twitter: https://twitter.com/erinstellato