Answer / swapna

Lock escalation is the process of converting a lot of low
level locks (like row locks, page locks) into higher level
locks (like table locks). Every lock is a memory structure
too many locks would mean, more memory being occupied by
locks.

To prevent this from happening, SQL Server escalates the
many fine-grain locks to fewer coarse-grain locks. Lock
escalation threshold was definable in SQL Server 6.5, but
from SQL Server 7.0 onwards it's dynamically managed by SQL
Server.

Define cursor locking

0 Answers  

---

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  

---

Why are sql functions used?

0 Answers  

---

Explain for xml explicit mode?

0 Answers  

---

What do you understand by mirroring?

0 Answers  

---

What do you understand by the denormalisation?

0 Answers  

---

About DTS usage ?

2 Answers   Cognizant, Wipro,

---

How to provide values to stored procedure parameters in ms sql server?

0 Answers  

---

What is normalization in Database ?

4 Answers  

---

What do you mean by data manipulation language?

0 Answers  

---