What is mapping schema?

1028

---

What is the downside of using udf?

1109

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

886

---

Where can you add custom error messages to sql server?

1125

---

What is the primary use of the model database?

1087

---

what is the difference between openrowset and openquery?

1088

---

Why and when do stored procedure recompile?

982

---

How can you append an identity column to a temporary table?

954

---

What is the difference between for xml raw and for xml auto?

1032

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1139

---

Why should you use or avoid select * statements?

1031

---

When should you use an instead of trigger?

956

---

What is an indexed view?

960

---

How can you know if the row fetched from cursor is still valid in underlying table?

998

---

What is the difference between a primary key and a unique key? Are they the same?

1077

---