Mastering Parameter Sniffing
All the tools to help troubleshoot and fix sniffing issues for good.
Mastering
What you will get:
- Watch on any Device
- 6 sections
- lectures
- of video
Last updated: 30 Sept 2022
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 Las Vegas, Nevada.
Course Description
You’ve conquered Fundamentals of Parameter Sniffing, and now you need to master all the different ways to mitigate parameter sniffing problems for good. Good news – I’ll teach you how in this 14-hour recorded class.
The class will take you longer to complete because it includes lab assignments that will take you hours to work through, and my students tell me they love doing these labs again and again. They're kinda like SQL Server video games! To follow along, you'll need to build your own SQL Server lab VM.
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: Mastering bundle.
Course Curriculum
- Lab 4 Setup and Class Recap (6:11)
- Working on usp_SearchPostsByPostType (54:48)
- Working on usp_RptFastestAnswers (95:26)
- Working on usp_SearchPostsByLocation (40:23)
- Working on usp_RptQuestionsAnsweredForUser (18:13)
- Working on usp_SearchUsers (49:59)
- Working on usp_RptUsersLeaderboard (14:51)
- Working on usp_RptPostLeaderboard (37:22)
- Working on usp_RptAvgAnswerTimeByTag (24:44)
- Working on usp_DashboardFromTopUsers (28:17)
- Working on usp_GetTagsForUser (12:16)