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

Which is the best place or learning center for MS SQL?????In Bangladesh?????

0 Answers   TCL, Wipro,

---

Why do we use non clustered index?

0 Answers  

---

Define outer join?

0 Answers  

---

What is Service Broker in sql server 2012?

0 Answers   UGC Corporation,

---

What is merge?

0 Answers  

---

---

How would you use user_constraints table in DB?

0 Answers   Wipro,

---

What are the pre-defined functions in the sql server?

0 Answers  

---

What is data source document?

0 Answers  

---

Difference between drill down and drill through report.

0 Answers  

---

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---

How to create a new table in a given schema?

0 Answers  

---

What is the maximum size of a row in sql server?

0 Answers  

---