What are types of storage modes? : sql server analysis services, ssas

0 Answers  

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  

---

What is dbcc? Give few examples.

0 Answers  

---

what is an extended stored procedure? : Sql server database administration

0 Answers  

---

What is the xml datatype?

0 Answers  

---

What number aggregate functions are accessible there in sql?

0 Answers  

---

What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

Define right outer join in sql server joins?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

What is nolock hint in sql server 2008

0 Answers   HCL,

---

How to select true false based on column value in sql server?

0 Answers  

---

Do you know what are the differences between lost updates and uncommitted dependencies?

0 Answers  

---