What are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

What is difference between rownum and row_number?

0 Answers  

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---

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 the new security features added in sql server 2016? : sql server security

0 Answers  

---

Explain differentiate between a having clause and a where clause?

0 Answers  

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

---

What is difference between delete and truncate commands?

0 Answers  

---

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 Answers  

---

What are the difficulties faced in cube development? : sql server analysis services, ssas

0 Answers  

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---