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.

Which virtual table does a trigger use?

3 Answers  

---

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

---

Why we need sql server?

0 Answers  

---

What is a partitioned view?

0 Answers  

---

---

What command is used to delete a table from the database in the sql server and how?

0 Answers  

---

how you can list all the tables in a database?

0 Answers  

---

What is the difference between a Application Server and a Database

3 Answers   Oracle,

---

How to specify the collation for a character data type in ms sql server?

0 Answers  

---

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,

---

How you can get a list of all the table constraints in a database? : Sql server administration

0 Answers  

---

What is the difference between OLEDB and ODBC

4 Answers   CFCI,

---