What is lock escalation and what is its purpose?

0 Answers  

---

How to declare and use cursor variables?

0 Answers  

---

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

---

What guidelines should be followed to help minimize deadlocks?

0 Answers  

---

What are the different types of columns types constraints in the sql server?

0 Answers  

---

Can sql servers linked to other servers?

0 Answers  

---

What can be used instead of trigger?

0 Answers   ADITI,

---

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers  

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

0 Answers   Microsoft,

---

What do you understand by check constraint in sql server?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

---