In this session, we are going to discuss about various concurrency problems that are identified in SQL Server like, Dirty Reads, Non-Repeatable Reads, Phantom Reads etc., We will also discuss about Optimistic Concurrency & Pessimistic Concurrency models and how SQL Server uses locking behind the scenes to maintain data consistency.
Keywords:
Important Links:
Follow SQLMaestros on Twitter |
|
Follow Amit Bansal on Twitter |
|
Subscribe To Newsletter |
|
SQLMaestros Video Courses |
|
SQLMaestros Hands-On-Labs |
|
Subscribe to Amit Bansal’s exclusive distribution list |
|
Join us on Telegram |
Leave A Comment