2.7 Lab 4 Setup: Solving Blocking with Indexes
Restore your Stack Overflow database, then run the setup script below. This will create a specialized set of indexes that will exhibit a different set of problems than we’ve experienced so far. Then, you’ll run Lab 4’s workload, and presto: we’ve got blocking. Your mission, should you choose to accept it, is to use sp_BlitzIndex […]
To access this incredible, amazing content, you gotta get Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.