SQL Server 2022: Here’s what you need to ... running on the latest application database compatibility level or turning on a database level configuration,” said Khan. The new features tweak ...

you can begin to see the major performance improvements your application can see just by upgrading to SQL Server 2022 and changing your database compatibility level to 160.

Two caveats: First, even if you’re working with SQL Server 2016, your database’s compatibility level must be set to 130 or higher to use these features. You can view your database’s compatibility ...

you could upgrade your SQL Server to a newer version and capture query performance while running under the old CE and an older compatibility level. As you upgraded to newer versions of both CE and ...