The Startup
Published in

The Startup

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.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store