Interested to Buy Any Domain ? << Click Here >> for more details...
What is live lock and deadlock?
what is Lock escalation?
- 2 Answers
- 9313 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
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
How to use group functions in the select clause in ms sql server?
What are the features of Embedded SQL
Does index speed up select statements?
What is the fillfactor concept in indexes?
How exceptions can be handled in sql server programming?
What do you do in data exploration
Define model database?
what are acid properties? : Sql server database administration
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What stored procedure would you use to view lock information?
what is the maximum size of a row? : Sql server database administration
Explain the types of indexes.
How to backup SQL Server Reporting Services ?
What are horizontal and vertical scaling?
