SQL Server Locks Question: Download MS SQL Server Locks PDF
What is Pessimistic concurrency?
Answer:
Pessimistic concurrency: Assumes that resource conflicts between multiple users are very likely to occur and hence locks resources as they are used by transactions for the duration of the transaction. A transaction is assured of successful completion unless a Deadlock ocurrs.
| Previous Question | Next Question |
| What is Optimistic concurrency? | Do you know the isolation level that SQL Server support? |