SQL Server Locks Question:

What is a live lock?

MS SQL Server Locks Interview Question
MS SQL Server Locks Interview Question

Answer:

When a request for exclusive lock is denied again and again because a series of overlapping shared locks are interfering with each other and to adapt from each other they keep on changing the status, it is known as live lock.


Previous QuestionNext Question
What is a dead lock?What is SQL Server locking?