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.

Equi join and non equi join is possible with sql server?

0 Answers  

---

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 Answers  

---

Explain relational data?

0 Answers  

---

What are the 10 characteristics of data quality?

0 Answers  

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

---

How can i change the column name.

13 Answers   HCL, Yardi Software,

---

What are the advantages of having an index on the sql server?

0 Answers  

---

What is difference between rollback immediate and with no_wait during alter database?

0 Answers  

---

optimization techinques

0 Answers   Wipro,

---

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

---

What is the difference between push and pull subscription? : sql server replication

0 Answers  

---

How to provide login information for a new odbc dsn?

0 Answers  

---