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

1086

---

What is a derived table?

991

---

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

1254

---

Will the writetext statement activate a trigger?

1154

---

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

1188

---

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

1041

---

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

1327

---

How do you rebuild an identity column?

996

---

Define a cross join?

1084

---

Explain an incremental backup?

1050

---

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

1129

---

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

986

---

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

1044

---

What are statistics?

1050

---

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

968

---