1.2 The D.E.A.T.H. Method: Dedupe and Eliminate (40m)
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.
- 0.1 Prerequisites Before the Class (~4 hours)
- 0.2 How to Set Up Your Own Lab Server
- 1.1 Introducing Your Lab Environment (17m)
- 1.3 D.E. Tools and Their Weaknesses (31m)
- 1.4a Lab 1: Dedupe and Eliminate – Introduction (25m)
- 1.4b Lab 1: Dedupe and Eliminate – Brent Does It (38m)
- 1.5 The D.E.A.T.H. Method: Tuning Indexes for Specific Queries (65m)
- 1.6a Lab 2: Tuning Indexes for Specific Queries – Introduction (5m)
- 1.6b Lab 2: Tuning Indexes for Specific Queries – Brent Does It (47m)
- 2.1 Adding Indexes with the DMVs (30m)
- 2.2 Tuning to Avoid Key Lookups and Residual Predicates (11m)
- 2.3a Lab 3: Adding Indexes with Clippy and the DMVs – Introduction (4m)
- 2.3b Lab 3: Adding Indexes with Clippy and the DMVs – Brent Does It (32m)
- 2.4 Tuning Indexes to Avoid Blocking (40m)
- 2.5a Lab 4: Solving Blocking with Indexes – Introduction (11m)
- 2.5b Lab 4: Solving Blocking with Indexes – Brent Does It (53m)
- 3.1 Filtered Indexes, Indexed Views, and Computed Columns (44m)
- 3.2a Lab 5: Leveraging Artisanal Indexes – Introduction (4m)
- 3.2b Lab 5: Leveraging Artisanal Indexes – Brent Does It (38m)
- 3.3 The D.E.A.T.H. Method – Heaps and Clustered Indexes (32m)
- 3.4 Foreign Key and Check Constraints (11m)
- 3.5 Tips from the Index Sommelier (23m)
- 3.6a Final Lessons and Lab 6 – Introduction (12m)
- 3.6b Lab 6: Doing the D.E.A. (28m)
- 3.6c Lab 6: Tuning Indexes for Specific Queries (32m)
- About the Lab Exercises