Category: SQL 2019

By Posted on Posted in Database Health, SQL 2019 No Comments Tagged with , , , , ,

Today I released the November 2018 (version 2.6.6) release of Database Health Monitor. Version 2.6.6 Release Notes Version 2.6.6 is the November 2018 Release of Database Health Monitor New Features in 2.6.6 Added a check in the Quick Scan report for databases running on an older compatibility level. Added a check to the Quick Scan report for serializable transactions. Added …

Released Today – Database Health Monitor – November 2018 Read more »

By Posted on Posted in SQL 2019, TSQL No Comments Tagged with , ,

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 »

By Posted on Posted in SQL 2019, TSQL 2 Comments Tagged with , ,

With SQL Server 2019, there is a new compatibility level introduced, level 150 the new SQL Server 2019 Compatibility Level. SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL …

SQL Server 2019 Compatibility Level Read more »