Video unavailable

SQLBits 2026

Performance and execution plan improvements in SQL Server 2025 (part 2)

SQL Server 2025 was officially released in November 2025. Join execution plan expert Hugo Kornelis as he takes an in-depth look at some of the new features that affect query performance and execution plans.

SQL Server 2025 was officially released in November 2025. Join execution plan expert Hugo Kornelis as he takes an in-depth look at some of the new features that affect query performance and execution plans - such as Optional Parameter Plan Optimization, Optimized Locking, and Optimized Halloween Protection.
What problems are these features trying to solve? How do they work? And do they achieve what they set out to do ... or do they merely cause a whole new set of problems to look out for?

Speaker

Hugo Kornelis's Sessions

Approximate functions: How do they work?

Execution plans ... where do I start?

Five stages of grief - internals of a hash spill

Here’s the execution plan … now what?

Normalization beyond Third Normal Form

Normalization beyond Third Normal Form, part 2

Performance and execution plan improvements in SQL Server 2025

Performance and execution plan improvements in SQL Server 2025 (part 2)

Now Where Did THAT Estimate Come From?

Here’s the execution plan … now what?

Parameter Sensitive Plan Optimization in SQL 2022 ... As Cool as it Sounds?

Execution plans ... where do I start?

Five stages of grief - internals of a hash spill

Here’s the execution plan … now what?

Fast Focus: Scalar User-defined Functions in SQL Server 2019

Execution plans ... where do I start?

From adaptive to intelligent: query procesing in SQL 2019

Normalization Beyond Third Normal Form

T-SQL User-Defined Functions, or: Bad Perf. Made Easy

All About Indexing

Everything you always wanted to know about MERGE

SQL Server 2012: Column store indexes