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.

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 ...