Find databases running on an older compatibility level
The SQL Server compatibility level is a SQL Server setting. This is the setting that controls some of the features of how the SQL Server database engine runs, for instance the cardinality estimator. Some people have found problems with certain queries when updating to SQL Server 2016 for instance due to the changes in the cardinality estimator. If you …
Find databases running on an older compatibility level Read more »