Where can you add custom error messages to sql server?

1190

---

What is the primary use of the model database?

1141

---

what is the difference between openrowset and openquery?

1174

---

Why and when do stored procedure recompile?

1042

---

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

1049

---

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

1095

---

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?

1200

---

Why should you use or avoid select * statements?

1094

---

When should you use an instead of trigger?

1033

---

What is an indexed view?

1013

---

How raid can influence database performance?

1093

---

How do I copy files recursively onto a target host?

10

---

How do I access a variable name programmatically?

11

---

Any work done in oracle workflow builder. Did you customize or build a new workflow?

6

---

Are you familiar with user exits in reports?

5

---