When tuning indexes, I use the D.E.A.T.H. Method: Dedupe identical (and near-identical) indexes Eliminate indexes that aren’t getting used Add indexes that the DMVs recommend (but analyze them first) Tune queries individually to hand-craft better indexes Heaps generally need clustered indexes In this module, I explain why I start with the D/E/A steps, and then...
To access this incredible, amazing content, you gotta get Live Class Season Pass, The Team Membership, Mastering Index Tuning, Level 3 Bundle (Live Classes, Lab VM Included) or Level 2 Bundle (Live Classes, No VM Included), or log in if you already shelled out the cash.