What is the difference between dbcc indexdefrag and dbcc reindex?

1035

---

What is the maximum length of an extended property?

1034

---

How can you fix a poorly performing query?

1253

---

What is the physical representation for a many-to-many relationship?

1133

---

What is an application role and explain a scenario when you would use one?

1056

---

Which data type cannot be used as a parameter in a udf?

1020

---

In which database can extended stored procedures be added?

949

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

1017

---

How you can make a parameterized view?

1069

---

Can an extended stored procedure be called from inside a user-defined function?

1110

---

How long can an error message be in raiseerror function?

1044

---

Write the fastest query to find out how many rows exist in a table?

1169

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1071

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1050

---

Explain the cube operator?

1059

---