n this high-octane session, Erik Darling tackles the notorious parameter sniffing problems that plague SQL Server performance. You'll learn to identify when the optimizer's plan caching decisions turn lightning-fast queries into server-crushing disasters due to shifting parameter values.

Through real execution plans, you'll see how SQL Server makes critical optimization choices based on first-seen parameter values, often creating performance catastrophes for subsequent executions. Erik demonstrates practical techniques to identify skewed distribution statistics and reveals battle-tested methods to take care and control of your execution plans.

Whether dealing with simple procedures that run fast for most users but tank for others, or complex multi-parameter queries where optimal plans vary wildly, you'll leave armed with concrete strategies to maintain stable performance regardless of parameter values.

Essential knowledge for any SQL professional tired of watching carefully tuned queries fall apart when parameters change.