Video unavailable

SQLBits 2022

Parameter Sniffing vs Parameter Sensitive Plan Optimization

A look at what SQL Server 2022's Parameter Sensitive Plan Optimization is and what problems it fixes

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

Speaker

Gail is a database specialist from Johannesburg, South Africa, working for Entelect Software.

Gail Shaw's Sessions

Introducing Synapse Analytics Data Explorer pools

Parameter Sniffing vs Parameter Sensitive Plan Optimization

Regressions, neurons and decisions. Oh My!

All about Indexes

All about Indexes

On Transactions and Atomic Operations

Do's and don'ts of database corruption