Interested to Buy Any Domain ? << Click Here >> for more details...
What is live lock and deadlock?
what is Lock escalation?
- 2 Answers
- 9417 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / 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).
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Write a sql query to get zero records from a table having n number of records?
How to override dml statements with triggers?
What is partitioned view?
What is cdc in sql server?
How does clustered and non clustered index work?
What is self contained sub query?
What is the purpose of sql profiler in sql server? : sql server database administration
What is difference between views and stored procedures?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What is the difference between SQL notification and SQL invalidation?
Define views.
Does partitioning improve performance?
How to achieve Paging of records in SQL SERVER?
Determine when to use stored procedure to complete sql server tasks?
What happens if you delete a table that is used by a view?
