Why does DROP PROCEDURE with the database name as a prefix give Error 166 when DROP TABLE works? Explain it and win my SQL Server Interview Questions and Answers book.
SQL SERVER – A Quick Look at Performance – A Quick Look at Configuration
Before I answer a performance question, I need to know the environment. Here is how I take a quick look at configuration to get the full picture fast.
Foreign Keys Across Databases: What to Use Instead
SQL Server will not create a foreign key to another database. Here is the real error, why a report is only detection, and a same-database option that enforces.
Error 3241 on Restore: Newer Version or Damaged Backup File
Error 3241 only says SQL Server could not read the file as a backup. Here are three broken files, three different messages, and the checks to run first.
SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object
Why using keywords as an object name is a bad practice: a stored procedure named GO runs with EXEC GO, and the result can surprise you.
Statement Terminators: Where T-SQL Requires a Semicolon
Most T-SQL statements run fine without a semicolon, but a pasted CTE, THROW or MERGE will not. Here is how to read the error and fix the line above it.
What a Junior DBA Should Learn First
Build junior DBA skills around restores, permissions, blocking, and safe investigation, with a practical learning order and useful SQL checks.







