Bonus: Storytelling Time
During the Fundamentals of Parameter Sniffing class, we went offtopic a few times during the breaks, so I’m sharing the videos here because they’re amusing. I leave these as open to the public because it gives you a feel for what the class breaks are like, and the quality of the audio & video of my classes.
About how I thought I was gonna feel when I left conferences, versus how I actually felt:
About which SQL Server product you’re using:
About tuning the number of steps in the statistics histogram, and why Microsoft isn’t fixing that problem:
Remembering Robert Davis, aka @SQLSoldier:
- 0.1 Prerequisites Before the Class
- 01. What Parameter Sniffing Is
- 02. The Kinds of Queries That Are Susceptible to Parameter Sniffing
- 03. Mo Choices, Mo Problems
- 04. Lab: Write a Query that’s Susceptible to Parameter Sniffing
- 05. What Triggers Parameter Sniffing Emergencies, Part 1
- 06. What Triggers Parameter Sniffing Emergencies, Part 2
- 07. How to React to Parameter Sniffing Emergencies
- 08. Lab: Tackle a Parameter Sniffing Emergency
- 09. What Parameter Sniffing ISN’T
- 10. How SQL Server 2022 Tries Fixing Parameter Sniffing
- 11. Class Recap