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/

Podden och tillhörande omslagsbild på den här sidan tillhör EightKB. Innehållet i podden är skapat av EightKB och inte av, eller tillsammans med, Poddtoppen.