What is the difference between dbcc indexdefrag and dbcc reindex?

932

---

What is the maximum length of an extended property?

924

---

How can you fix a poorly performing query?

1103

---

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

1010

---

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

949

---

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

909

---

In which database can extended stored procedures be added?

855

---

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?

890

---

How you can make a parameterized view?

953

---

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

1002

---

How long can an error message be in raiseerror function?

937

---

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

1054

---

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

948

---

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?

947

---

Explain the cube operator?

936

---