Query Performance Enhancements in SQL Server 2025

Query tuning has always been a challenge. There is always so much to learn and understand in order to identify where your bottlenecks may be and then know how to address them. While SQL Server 2025 may not make query performance improvement easy, it certainly does make it easier. Come to this session to learn how various enhancements from improvements in Parameter Sensitive Plans (aka Parameter Sniffing) to Optimized Locking, all come together in SQL Server 2025 to help your queries run faster. You'll learn which of these improvements is on by default, and which ones you may want to switch on. Along the way we'll even talk a little Extended Events and some DMVs. You can make SQL Server run faster, and 2025 will help you along that path.

Learn about the new functionality focused on query performance in SQL Server 2025. Understand how many of the new functions and features work to enhance query performance. Appreciate the potential limitations and pitfalls when putting these new functions to work.