What are the different types of backups that exist?

0 Answers   ADITI,

---

Which databases are part of SQL server default installation? Explain the usage of each?

2 Answers   Accenture,

---

Explain user defined functions?

0 Answers  

---

What’s the use of custom fields in report?

0 Answers  

---

What are the different types of stored procedures?

0 Answers  

---

---

Tell me what is difference between clustered and non clustered index?

0 Answers  

---

What are the authentication modes in sql server? How can it be changed?

0 Answers  

---

Describe how to use linked server?

0 Answers  

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  

---

What is a coalesce function?

0 Answers  

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  

---

What kind of problems occurs if we do not implement proper locking strategy?

0 Answers  

---