Answer / sagi.rahul

In SQL Server Live Lock occurs when read transactions are
applied on table which prevents write transaction to wait
indefinitely and Deadlocking occurs when two user processes
have locks on separate objects and each process is trying to
acquire a lock on the object that the other process has.

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).

Answer / zeeshu

LIVE LOCK: when a process is running but it doesnt do any useful work at all but it consumes the cpu time.


DEADLOCK: IN SIMPLE MEANING when a process is requesting for a resource which is held by some other process,and that process is waiting for the resource which is holding by the previous process,then there is a condition of deadlock....

converting low level lock to high level lock is lock escalation

What are pessimistic lock and optimistic lock?

0 Answers  

---

What are logical/boolean operations in ms sql server?

0 Answers  

---

What does it mean to invest in the index?

0 Answers  

---

What is the difference between dataadapter and datareader?

0 Answers  

---

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

---

What are the new features in SQL Server 2005?

3 Answers   Emphasis,

---

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,

---

How to test values returned by a subquery with the in operator?

0 Answers  

---

Explain about extended stored procedure?

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,

---

What is normalization and what are the advantages of it?

0 Answers  

---

How to rebuild indexes with alter index ... Rebuild?

0 Answers  

---