Compatibility Level Check / Set - performance Issue - Sql Server

Jul 22, 2019 BY xtreme
To Compatible Transact-SQL and query processing behaviors with the specified version of the SQL Server Database Engine.

   -- To check the compatibility level:
   select compatibility_level from sys.databases where name = ''

   -- To set the compatibility level:
   alter database database_name set compatibility_level = compatibility_number

   -- Different compatibility levels are
   { 150 | 140 | 130 | 120 | 110 | 100 | 90 }

	
Related