1.6a Lab 2: Tuning Indexes for Specific Queries – Introduction

Now let’s take the reverse problem: let’s start with nothing. We’ll drop all of the nonclustered indexes in our Stack Overflow database, then run the demo workload again. This time, we’re going to use sp_BlitzCache to list the most resource-intensive queries, look at Clippy’s index recommendations for them, and hand-craft our own indexes instead. 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.

Now let’s take the reverse problem: let’s start with nothing. We’ll drop all of the nonclustered indexes in our Stack Overflow database, then run the demo workload again. This time, we’re going to use sp_BlitzCache to list the most resource-intensive queries, look at Clippy’s index recommendations for them, and hand-craft our own indexes instead. 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":""}