A 1 AM call: TempDB was full on the C drive. Here is the popular interview question on moving TempDB to new drive, with the steps I use.
What is a Master Database in SQL Server? – Interview Question of the Week #076
A reader told me he had dropped his master database. So here is the basic question: what is a master database in SQL Server, and why does it matter?
Can We Have NULL Value in Primary Key? – Interview Question of the Week #075
Can we have a NULL value in primary key columns? No. The primary key has to uniquely identify each row, and NULL cannot do that. Here is why.
SQL SERVER – How Much Free Space I Have in My Database?
Free Space inside data files differs from unused space on the Windows volume. I check both when planning growth.
Sort Query Using Dynamic Variables Without EXEC – Interview Question of the Week #074
How do you sort query results by a column passed in a variable? Here is how to sort query output dynamically without EXEC or sp_executesql.
What is NOT NULL Constraint? – Interview Question of the Week #073
A client table full of NULL values was hurting query plans. Here is what a NOT NULL constraint is, how to add one and why it helped performance.
SQL Domain Controller – Interview Question of the Week #072
SQL domain controller questions: can SQL Server run on one? Five interview answers, checked against Microsoft’s current guidance, one corrected.