SQL Server Transactions and Isolation Levels
As developers, we don’t always think too deeply about the database internals and that can result in poor performance and unexpected concurrency issues.
This article represents my learning progress in diving into SQL Server’s concurrency features.
In this article we’ll discuss transactions and isolation levels / read modes.
By default, when you write SQL it runs in an autocommit transaction, which means each statement will be committed to the database after it is executed.