01. What Parameter Sniffing Is
We’ll start by defining what parameter sniffing is: a query that builds a dramatically different plan depending on what parameters are first used to compile it. We’ll begin with a query that uses literal values, show two different parameters that produce different plans, and show what happens when it’s put into a stored procedure. Demo […]
To access this incredible, amazing content, you gotta get Recorded Class Season Pass, Fundamentals of Parameter Sniffing – Live Classes + Instant Replay, 1 Year Access or Fundamentals of Parameter Sniffing – Instant Replay Recordings Only, 1 Year Access, or log in if you already shelled out the cash.