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.

How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,

---

How do I create a trace in sql server?

0 Answers  

---

Explain about link server in sql server?

0 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  

---

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

---

How to truncate the log in sql server 2012? : sql server database administration

0 Answers  

---

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

2 Answers   IBM, TCS,

---

How to convert a numeric expression from one data type to another?

0 Answers  

---

what are constraints? : Sql server database administration

0 Answers  

---

How can I check if a view exists in a sql server database?

0 Answers  

---

Does a server store data?

0 Answers  

---

What do you do in data exploration

0 Answers   EXL,

---