Locking in SQL Server | with DEMO | Why do we need Locking ? | SQL interview Q&A
Locking is the way that SQL Server manages transaction concurrency and it ensures the integrity of the data in the database, as it forces every SQL Server transaction to pass the ACID test.
Contents in this video:
1. What is Locking in SQL server
2. Locking hierarchy
3. Why do we need locking
4. Demo on how Locking occurs
5. Locking Resources and Modes of Locking
ACID properties in SQL Server
• ACID properties in SQL server | Atomi...