Answer Posted / abcd

9 indexes:

1. Clustered,
2. Non-clustered,
3. Unique,
4. Index with included columns,
5. Indexed views,
6. Full text,
7. Spatial,
8. Filtered &
9. XML

How to perform backup for certificates in sql server? : sql server security

1145

---

Explain the difference between clustered and non-clustered index?

971

---

Explain what is raid and what are different types of raid levels?

1094

---

What are the different types of indexes?

1160

---

Explain few examples of RDBMS?

1102

---

Why we should not use triggers?

1016

---

Do you know what is replace and stuff function in sql server?

1082

---

What is the difference between set and select?

1163

---

What is the syntax for encrypting a column in SQL Server?

1175

---

What are the properties of the transactions?

1171

---

Explain candidate key, alternate key, and composite key?

1060

---

Is ssrs support other database except ms sql server?

142

---

What is a transaction and why is it important?

1166

---

What is the purpose of the master database?

1200

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

1048

---