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

Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,

---

How to find the date and time of last updated table?

6 Answers   Teledata,

---

How to provide Security for package?

1 Answers   Convergys,

---

What are the different types of collation sensitivity in sql server?

0 Answers  

---

does physical index sort data

1 Answers  

---

---

State a few properties of relational databases?

0 Answers  

---

What are the differences between clustered and non-clustered index?

0 Answers  

---

What is model database in sql server?

0 Answers  

---

How do I make a resultset scrollable?

0 Answers  

---

What is the importance of concurrency control?

0 Answers  

---

How to delete duplicate rows in sql server?

0 Answers  

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

0 Answers   MCN Solutions,

---