Your problem query
- Why is this a problem? (7 minutes)
- Download the scripts and slides
- Meet your problem query (20 minutes)
Why did the query get slower?
- Explore the slow query's execution plan (15 minutes)
- Why did the query slow down? (5 minutes)
Rewriting the query
- TSQL rewrites that do NOT fix the problem (5 minutes)
- Solutions with index hints and local variables (13 minutes)
- Using a temp table as a fake variable (8 minutes)
- Solutions using Dynamic SQL (14 minutes)
Summing up - and a quiz!
- Which solution is best? (3 minutes)
- Test your knowledge in the course quiz
- Feedback / course survey