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 can I know what locks are running on which resource?

0 Answers  

---

How to recreate an existing index in ms sql server?

0 Answers  

---

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

0 Answers   IntraLogic, Oracle,

---

What Is Rdbms?

0 Answers   Accenture,

---

How reterive duplicate value in SQL?

6 Answers  

---

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

---

What is the temp table?

0 Answers  

---

What are the various Isolation levels?

2 Answers   HP,

---

What is an index?

8 Answers   Yardi Software,

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

What is 1nf 2nf?

0 Answers  

---