Parameter Sniffing vs Parameter Sensitive Plan Optimization

SQL Server 2022 introduced the concept of Parameter Sensitive Plan Optimization. In this session, we'll look at what exactly Parameter Sensitive Plan Optimization is, and see how effectively it solves the old problem of parameter sniffing

Understand what parameter sniffing is and what causes it Know how Parameter-sensitive plans work Learn how to identify cases where the automatic fixes fail