Fundamentals of Parameter Sniffing
Sometimes a query just goes slow for no apparent reason.
Fundamentals
What you will get:
- Watch on any Device
- 4 sections
- lectures
- of video
Last updated: 05 March 2021
Your Instructor
I make Microsoft SQL Server go faster. I've been working with SQL Server since the late 1990s, and I'm one of the rare Microsoft Certified Masters of SQL Server. I love teaching, travel, and laughing. I live in San Diego, California and Cabo San Lucas, Mexico.
Course Description
A query just suddenly runs slowly. Your fix is to update stats or rebuild indexes. It seems to work, but you don’t know why, and it keeps coming back. Understand why in this recorded class. (This is not a live class - if you want to attend live, check out my Live Class Season Pass.)
Want to save a bundle? This class is included in my Recorded Class Season Pass: Fundamentals bundle.
Course Curriculum
Before the Class
Available in
days
days
after you enroll
Parameter Sniffing and Which Queries are Vulnerable
Available in
days
days
after you enroll
When Parameter Sniffing Emergencies Strike (and Why)
Available in
days
days
after you enroll
Finishing Things Up
Available in
days
days
after you enroll