Why do we need hints and optimizer hotfixes?
- Why do we need hints and optimizer hotfixes? (3 minutes)
- Download course scripts and slides
Query tuning with hints
- Why hints aren't "suggestions", and a tour of our slow query (12 minutes)
- Hinting cardinality estimation level and setting row goals (15 minutes)
- Join hints, temp tables, and table variables (13 minutes)
- Hints lead to a query rewrite, and hinting away a nonclustered columnstore index (8 minutes)
- Getting creative with TSQL rewrites (15 minutes)
- Frequently used hints (10 minutes)
- Quiz: hints!
Recompile hints aren't created equal
- What 'recompile' means (3 minutes)
- A super simple load test of recompile hints (15 minutes)
- Recompile bugs and best practices (4 minutes)
- Recompile quiz
How to "take out" an execution plan
- Bumping execution plans out of cache (8 minutes)
Query optimizer hotfixes
- Query optimizer hotfixes and trace flag 4199 (7 minutes)
- Reproducing a bug and showing query optimizer hotfixes at work (11 minutes)
- When to use query optimizer hotfixes and TF 4199 (4 minutes)
- Test your knowledge on query optimizer hotfixes
Interview questions and answers
- How to use the interview questions (1 minute)
- Interview Question #1 (2 minutes)
- Interview Question #2 (1 minute)
- Interview Question #3 (2 minutes)
- Course survey
SQLChallenges come out each month for registered students.
Check out the schedule and sign up for notifications here.