02: Indexing and Stats Maintenance
Mixed Extents - Un pódcast de EightKB
Categorías:
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/