Answer Posted / chiru

1

If a stored procedure is taking a table data type, how it looks?

5805

---

How can you start sql server in different modes?

509

---

What is stored procedures?

548

---

Explain the concept of recursive stored procedure.

497

---

How to apply cascading referential integrity in place of triggers?

570

---

---

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

116

---

What is the recovery model?

564

---

How is sql used in sql server?

503

---

What is data compression? : sql server database administration

549

---

What is the architecture of ms sql reporting service?

530

---

What is sql azure database?

188

---

How do I start sql server 2017?

533

---

What is query optimization process?

521

---

What are the advantages of using a stored procedure?

561

---

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

583

---