1.6 Lab 2 Setup: Analyzing a Running Workload

In this lab, I give you a little freedom to choose for which level of challenge is right for you: Easiest: tune a single query. Restart your SQL Server, restore your Stack Overflow database, run the setup script below, then open mqt_Lab2_Level1 and work on tuning it. Read the stored proc’s code to learn about…

To access this incredible, amazing content, you gotta get Mastering Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.