What is the difference between dbcc indexdefrag and dbcc reindex?

981

---

What is the maximum length of an extended property?

983

---

How can you fix a poorly performing query?

1174

---

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

1072

---

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

1004

---

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

968

---

In which database can extended stored procedures be added?

899

---

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?

959

---

How you can make a parameterized view?

1008

---

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

1049

---

How long can an error message be in raiseerror function?

999

---

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

1109

---

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

1008

---

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?

995

---

Explain the cube operator?

997

---