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 happens if null values are involved in arithmetic operations?

0 Answers  

---

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---

What is sql sandbox in sql server?

0 Answers  

---

what is the disadvantage of SQL Loder?

1 Answers   TCS,

---

Why truncate is ddl?

0 Answers  

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

what is normalization? : Sql server database administration

0 Answers  

---

When do u use clustered index and non-clustered index?

3 Answers   IBM,

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

0 Answers  

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

Give main differences between "Truncate" and "Delete".

0 Answers   HCL,

---