What are the differences between clustered and non-clustered index?

0 Answers  

---

how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,

---

Why we use functions in sql server?

0 Answers  

---

Explain the categories of stored procedure?

0 Answers  

---

What are the authentication modes in SQL Server?

4 Answers   IBM, iSmart,

---

---

how many triggers you can have on a table? : Sql server database administration

0 Answers  

---

What does the on delete cascade option do?

0 Answers  

---

What are the purposes of floor and sign functions?

0 Answers  

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

---

What is named calculation? : sql server analysis services, ssas

0 Answers  

---

How to rebuild master databse?

0 Answers  

---

What is the sql case statement used for? Explain with an example?

0 Answers  

---