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 user defined datatypes and when you should go for them?

1 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  

---

What is multilevel indexing?

0 Answers  

---

what is lazy writer?

1 Answers   Wipro,

---

What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,

---

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

---

Is sql server implemented as a service or an application? : Sql server database administration

0 Answers  

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---

How to drop an existing user defined function in ms sql server?

0 Answers  

---

How to Rebuild Master database in sql server 2005.

2 Answers   Wipro,

---