SESSION Details

Options for Proactively Managing Statistics in SQL Server

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

Starts: 13:40 10th Mar 2022
Ends: 14:00 10th Mar 2022

Q&As

Short Description
- 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.

Slidedeck Link

Stellato_Stats.zip

Speakers

Erin Stellato

Tags

AzureOn PremisesOperational DatabasesManagingAzure SQL DatabaseSQL 2019SQL 2022IntermediateHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference

Previous
Next

Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.