What is the difference between dbcc indexdefrag and dbcc reindex?

1042

---

What is the maximum length of an extended property?

1041

---

How can you fix a poorly performing query?

1258

---

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

1141

---

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

1063

---

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

1024

---

In which database can extended stored procedures be added?

954

---

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?

1020

---

How you can make a parameterized view?

1071

---

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

1117

---

How long can an error message be in raiseerror function?

1047

---

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

1174

---

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

1077

---

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?

1056

---

Explain the cube operator?

1060

---