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 enter comments in transact-sql statements?

0 Answers  

---

What is the disadvantages of index?

3 Answers   TCS,

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  

---

Does a server store data?

0 Answers  

---

How does normalization work?

0 Answers  

---

How to check if a table is being used in sql server?

0 Answers  

---

How to replace null values in expressions using isnull()?

0 Answers  

---

How do clustered indexes store data?

0 Answers  

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

How do I partition a table in sql server?

0 Answers  

---

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---

Can we add an identity column to decimal datatype?

0 Answers  

---