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 procedure in sql?

2 Answers   Millennium, SQL,

---

Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

---

What is identity?

0 Answers  

---

What does it mean to invest in the index?

0 Answers  

---

Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,

---

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

---

what are the different ways to return the rowcount of a table?

0 Answers   Microsoft,

---

What does the on update no action do?

0 Answers  

---

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

---

Explain Active/Active and Active/Passive cluster configurations

2 Answers  

---

Explain relational data?

0 Answers  

---

How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  

---