Need to know how much space your indexes use? Here is a script I share with clients that lists all the indexes in a database along with their size.
How Many Foreign Key Can You Have on A Single Table? – Interview Question of the Week #096
How many foreign key references can you have on a single table? I said 253 at SQLPASS, but my answer was not complete. Here is the full answer.
Performance Comparison EXCEPT vs NOT IN – Interview Question of the Week #095
EXCEPT vs NOT IN: which is faster? An attendee at PASS Summit asked me, and my simple example shows they work the same way and perform the same.
Fastest Way to Display Code of Any Stored Procedure – Interview Question of the Week #094
What is the fastest way to display code of any stored procedure? It is not always clicking Modify in SSMS. Here is the age old interview question and my answer.
When was Domain Account Password Changed in SQL Server? – Interview Question of the Week #093
Error 1069, logon failure, often means the service account password changed in the domain. Here is how to find when a Domain Account Password was last changed.
What is a Backup Timeline for Restore Process? – Interview Question of the Week #092
Question: What is a Backup Timeline for Restore Process?
Answer: One of the most popular interview question about Backup and Restore Database process.
How to Introduce Time Delay Between Two T-SQL Commands? – Interview Question of the Week #091
How do you introduce a Time Delay between two T-SQL commands? An interview question developers ask often, answered with WAITFOR DELAY.