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 are information schema views?

0 Answers  

---

Does index speed up select statements?

0 Answers  

---

Explain sub-query?

0 Answers  

---

I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  

---

How do you debug a procedure in sql server?

0 Answers  

---

What are the results of running this script?

0 Answers  

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

---

How is foreign key related to primary key?

0 Answers  

---

What is the default schema of your login session in ms sql server?

0 Answers  

---

Which are the new data types introduced in sql server 2008?

0 Answers  

---