1.4b Lab 1: Dedupe and Eliminate – Brent Does It
Armed with nothing but sp_BlitzIndex and my wits – okay, well, sp_BlitzIndex anyway – watch as I tackle a wildly over-indexed copy of the Stack Overflow database. I’ll tackle the D.E. portions of the D.E.A.T.H. method. Sample Answers Transact-SQL /* SQL2019 2021-02-12 Index Analysis, Valentine’s Day Edition Researched size with: sp_BlitzIndex @GetAllDatabases = 1, @Mode […]
To access this incredible, amazing content, you gotta get Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.