- The case begins (2 minutes)
- Meet your problem stored procedure (10 minutes)
- Your perf tuning challenge (3 minutes)
- Download scripts, slides, and a desktop wallpaper for the case
Solve the case
- Analyzing what we've learned so far (3 minutes)
- A test: what if I update fewer rows? (6 minutes)
- Comparing execution plans (7 minutes)
- Procedures vs ad-hoc TSQL (11 minutes)
- Speeding up the temp table (10 minutes)
- Course satisfaction survey
SQLChallenges come out each month for registered students.
Check out the schedule and sign up for notifications here.