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.

What are the different types of replication? How are they used?

3 Answers  

---

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  

---

What is the command dbcc checkdb used for?

0 Answers  

---

How to override dml statements with triggers?

0 Answers  

---

what is the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

---

What is sub query and its properties?

0 Answers  

---

What are the results of running this script?

0 Answers  

---

What is the difference between a Application Server and a Database

3 Answers   Oracle,

---

What is a non equi join?

0 Answers  

---

Can we perform backup restore operation on tempdb?

0 Answers  

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers   Value Labs,

---

What are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,

---