Tag: Sql

Understanding SQL Server Deadlocks

This is a continuation of a series of articles I’ve written on SQL Server concepts. When you work with SQL Server long enough on a database with enough traffic, you’re eventually going to encounter deadlocks. This article discusses what deadlocks are, how to interpret deadlock graphs, and some options for […]

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, […]