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 list all tables having unique constraints in any of the columns in a database.

1 Answers  

---

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

0 Answers  

---

What are the mathematical functions supported by sql server 2005?

0 Answers  

---

plss anybody specify tha constrian management system in dbms

0 Answers   Police Constable,

---

How to count rows with the count(*) function in ms sql server?

0 Answers  

---

Why olap is used?

0 Answers  

---

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

What are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,

---

What is user stored procedure & it purpose?

4 Answers   Wipro,

---

Can you please differentiate between a primary key and a unique key?

0 Answers  

---

optimization techinques

0 Answers   Wipro,

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  

---