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 is victor class

0 Answers  

---

How do indexes help, types?

0 Answers  

---

How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,

---

What is difference between views and tables?

0 Answers  

---

What is #temp and @table variable in SQL server?

0 Answers  

---

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

What is difference between global temporary tables and local temporary tables?

0 Answers   Tech Mahindra,

---

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

---

can a database be shrunk with users active? : Sql server administration

0 Answers  

---

How can we solve concurrency problems?

0 Answers  

---

Distinguish between nested subquery and correlated subquery?

0 Answers  

---

Define views.

0 Answers  

---