An Untrusted Foreign key has not validated all existing rows. A customer bulk-load history prompted this inventory.
RESOURCE_SEMAPHORE vs THREADPOOL: Two Waits, Two Fixes
RESOURCE_SEMAPHORE vs THREADPOOL tells you whether a task waits for memory or for a worker thread. This post reads both counters and checks for live waits. A demo shows how an index shrinks a memory grant from 38,216 KB to zero.
Index Build Speed: Which Rebuild Settings Change the Time
Index build speed depends on rebuild or reorganize, MAXDOP, ONLINE, SORT_IN_TEMPDB and the recovery model. This post times each choice on a million row table and measures the log under each recovery model. It shows which one changes the clock and which changes only the log.
Forwarded Records, Multiple Backup and SSMS – SQL in Sixty Seconds – Feb 2021
This month’s SQL in Sixty Seconds topics were Forwarded Records, Multiple Backup and SSMS. Here are the videos released in Feb 2021.
SQL SERVER – Get Column Names
I Get Column names using a schema-qualified table and a defined column order. The four methods use corrected filters.
Normalisation in Plain Words, and When to Stop
Understand normalisation through one order example, then decide when a reporting copy is worth the cost of keeping duplicated data consistent.
SQL SERVER – Fix: There is already an object named ‘MyFirstTable’ in the database
Recently I had a very interesting scenario with a client when they faced an error about already object named that exist in the database.