Answer Posted / ali razvi

N-1

Explain what is scheduled job and how to create it?

549

---

Detail about query optimizer?

616

---

What is normalization and what are the advantages of it?

522

---

what is a self join? : Sql server database administration

526

---

What is executereader?

555

---

---

How to disable a login name in ms sql server?

595

---

What is transaction server distributed transaction?

563

---

What is stored in the mssqlsystemresource database? : sql server database administration

596

---

Where can you add custom error messages to sql server?

587

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

528

---

Explain few examples of stored procedure over triggers?

525

---

Does group by sort data?

516

---

How to move database physical files in ms sql server?

534

---

What are the recovery models for a database?

620

---

what data regions are and what are the different data regions?

101

---