One thing impressed me about the latest version of SQL Server 2019 is its support to Compatibility Level from 2008 to 2019.
How to check the ANSI Compatibility of SQL Server Queries? – Interview Question of the Week #221
How do you check the ANSI compatibility of SQL Server queries? A client asked me this unique question, and the FIPS standard helps keep your code portable.
SQL SERVER – Fix Error: Invalid object name STRING_SPLIT
A reader on SQL Server 2016 got Invalid object name STRING_SPLIT when trying the new function. Here is why the error shows up and how to fix it.
SQL SERVER – Compatibility Level 80 and Table Hint Behavior
A health check led me to a database on compatibility level 80, sudden deadlocks and a surprise in table hint behavior. Here is what I found.
SQL SERVER – Different Methods to Know COMPATIBILITY LEVEL of a Database
Different methods to find the compatibility level of a database, from sp_helpdb to sp_dbcmptlevel, with a quick note on what the setting means.
SQL Server – Configuration Manager Console Running Very Slow and Time Out
During a performance health check, a client’s Configuration Manager Console ran very slow and timed out. Here is what we found in SQL Server behind it.
SQL SERVER – 2005 – Change Compatibility Level – T-SQL Procedure
The safe way to change compatibility level in SQL Server 2005: single user mode, sp_dbcmptlevel, then multi user again, and how to check it.