![Mixed Extents artwork](https://is2-ssl.mzstatic.com/image/thumb/Podcasts124/v4/a1/20/20/a120205b-553c-8fea-461f-62b84ddd77f0/mza_17064745575777903248.png/100x100bb.jpg)
02: Indexing and Stats Maintenance
Mixed Extents
English - September 25, 2020 16:00 - 53 minutes - 15.4 MBTechnology Homepage Download Google Podcasts Overcast Castro Pocket Casts RSS feed
In this episode we talk with Erik Darling and Erin Stellato about index maintenance, statistics, and the Index Maintenance Revolution! We also get to see more failed attempts at getting Andrew's name correct during our intro.
RESOURCES
From Erin:
https://www.sqlskills.com/blogs/erin/updating-statistics-with-ola-hallengrens-script/
https://www.sqlskills.com/blogs/erin/sqlskills-sql101-updating-sql-server-statistics-part-i-automatic-updates/
https://www.sqlskills.com/blogs/erin/sqlskills-sql101-updating-sql-server-statistics-part-ii-scheduled-updates/
https://www.sqlskills.com/blogs/erin/troubleshooting-a-change-in-query-performance/
From Erik:
https://www.erikdarlingdata.com/sql-server/because-your-index-maintenance-script-is-measuring-the-wrong-thing/
https://www.erikdarlingdata.com/sql-server/what-metrics-does-rebuilding-indexes-improve/
https://www.erikdarlingdata.com/sp_humanevents/
https://www.erikdarlingdata.com/sp_pressuredetector/
GUESTS
Erik Darling
Blog: https://www.erikdarlingdata.com/
Twitter: https://twitter.com/erikdarlingdata
Erin Stellato
Blog: https://www.sqlskills.com/blogs/erin/
Twitter: https://twitter.com/erinstellato
Intro sound from Freesound: https://freesound.org/people/Kleber_KGF/sounds/354019/