Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What is a derived table?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
Will the writetext statement activate a trigger?
Other than truncate statement, which other command can by-pass the trigger on the tables?
Is it important for a database administrator to understand the operating system and file access?
What is the fastest way to permanently delete a 1 million row table named customers?
How do you rebuild an identity column?
Define a cross join?
Explain an incremental backup?
How will you know when statistics on a table are obsolete?
How you can find out if an index is useful to the optimizer?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What are statistics?
Can a unique index be created on a column, which contains null?