© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
B. WardSQL Server 2022 Revealedhttps://doi.org/10.1007/978-1-4842-8894-8_5

5. Built-In Query Intelligence Gets Even Better

Bob Ward1  
(1)
North Richland Hills, TX, USA
 

In Chapter 4 you learned the history behind built-in query intelligence and its promise: getting you faster performance with no code changes. You learned about new SQL Server 2022 capabilities like the new Query Store, memory grant feedback persistence, and others. None of these require a change to the new dbcompat level 160 for SQL Server 2022.

What if you want all of what you read in Chapter 4 and more? If you change your dbcompat level to 160, you will definitely get more. This includes the ...

Get SQL Server 2022 Revealed: A Hybrid Data Platform Powered by Security, Performance, and Availability now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial