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

Why use stored procedures in sql server?

1 Answers  

---

How to genrate automaticlly empid like gt001

4 Answers  

---

How to loop through returning rows?

1 Answers  

---

What have included columns when we talk about sql server indexing?

1 Answers  

---

how to do partition in sqlserver

1 Answers   TCS,

---

how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,

---

Do you know what is lock escalation?

1 Answers  

---

write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

---

What method is used by the Command classes to execute SQL statements that return single values?

1 Answers   B-Ways TecnoSoft,

---

What is the difference between a clustered index and a non-clustered index?

1 Answers  

---

How do I find the transaction log size in sql server?

1 Answers  

---

What is acid properties?

1 Answers  

---