Monitor tempdb space usage with separate data-file and log checks. Find task allocations and open transactions before choosing a remedy.
Triggers That Assume One Row: Fixing Them for Multi-Row Updates
Fix triggers for multi-row updates by joining inserted and deleted, testing complete audit coverage, and keeping transaction work small.
SQL SERVER – Error Msg 10778, Level 16 with InMemory OLTP
Can an InMemory table have a foreign key to a disk-based table? I tried it and got Msg 10778. Here is what the error means and the limits to know.
SQL SERVER – Understanding JSON NULL Value Using STRICT Keyword
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.
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.