Why does a JSON path that doesn’t match return NULL? Add the STRICT keyword to get an error instead. A follow-up on JSON NULL values in SQL Server 2016.
Find All Queries with Implicit Conversion in SQL Server – Interview Question of the Week #107
Question: How do I find out how many queries have an Implicit Conversion in SQL Server? The source of this question is very interesting.
SQL SERVER – Script level upgrade for database master failed – Error: 4860, Severity: 16, State: 1 – Cannot bulk load. SqlTraceCollect.dtsx does not exist
SQL Server would not start after patching: script level upgrade for database master failed with error 4860, SqlTraceCollect.dtsx does not exist. The fix.
SQL SERVER – SQL Installation fails with error code 0x851A001A – Wait on the Database Engine recovery handle failed
SQL Server setup failed with 0x851A001A: Wait on the Database Engine recovery handle failed. The ERRORLOG showed error 17120. Here is what caused it.
SQL SERVER – Using dm_db_stats_properties With InMemory OLTP Tables
Does sys.dm_db_stats_properties show modified rows for InMemory OLTP tables? I tested it, and memory-optimized tables are now covered. Here is what I found.
SQL Server Performance Mistakes: Three Checks to Run Today
SQL Server performance mistakes hide in the settings, the files and the code. This post checks four server settings, shows poor file growth and its fix, and measures two code mistakes, a function on an indexed column and a data type mismatch, in logical reads.
SQL SERVER – Script level upgrade for database ‘master’ failed – There is already an object named ‘DatabaseMailUserRole’ in the database
After patching, script level Upgrade for master failed: there is already an object named ‘DatabaseMailUserRole’. Here is what caused it and how to fix it.