1.2 The D.E.A.T.H. Method: Dedupe and Eliminate

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, Live Class Season Pass PLUS Lab VM or Mastering Index Tuning, or log in if you already shelled out the cash.

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, Live Class Season Pass PLUS Lab VM or Mastering Index Tuning, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}