Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1089

---

What is a derived table?

995

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1257

---

Will the writetext statement activate a trigger?

1156

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1196

---

Is it important for a database administrator to understand the operating system and file access?

1045

---

What is the fastest way to permanently delete a 1 million row table named customers?

1339

---

How do you rebuild an identity column?

999

---

Define a cross join?

1084

---

Explain an incremental backup?

1053

---

How will you know when statistics on a table are obsolete?

1131

---

How you can find out if an index is useful to the optimizer?

987

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

1050

---

What are statistics?

1055

---

Can a unique index be created on a column, which contains null?

970

---