3.3 The D.E.A.T.H. Method – Heaps and Clustered Indexes (32m)
In most cases, when you tune an existing database, it’ll already have clustered indexes. However, we need to talk about what happens when it doesn’t: should you design a clustered index for it, or leave it as a heap? This lecture & demos explains the problems with wide clustering keys, show why IDENTITY fields are...
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.2 The D.E.A.T.H. Method: Dedupe and Eliminate (40m)
- 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.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