3.2 Lab 5: Parameter Sniffing (90m)

Now that you understand the 6 major ways to mitigate parameter sniffing, it’s your turn. Step into the lab, take 3 stored procedures, figure out why parameter sniffing is causing issues for them, and change ’em in the easiest/safest/fastest ways possible. Introducing the Lab (5m) Brent Works on sniff_AcceptedAnswersByUser (32m) Brent Works on sniff_CheckForVoterFraud (16m)…

To access this incredible, amazing content, you gotta get Live Class Season Pass or Mastering Query Tuning, or log in if you already shelled out the cash.