What are magic tables in sql server?

617

---

List few advantages of stored procedure.

528

---

What is the difference between locking and multi-versioning?

520

---

Differentiate between a local and a global temporary table?

539

---

Explain the collation?

620

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

506

---

Describe how to use linked server?

535

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

523

---

Give a example to search fr a string in all stored procedure in sql server.

526

---

Explain the etl (extraction, transformation, and loading)?

552

---

What is a trace frag?

631

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

498

---

What is similarity and difference between truncate and delete in sql?

579

---

Difference between drill down and drill through report.

540

---

What is openxml in sql server?

608

---