↓ Skip to Main Content
Vedran Kesegic Blog
Vedran Kesegic Blog

Main Navigation

  • Home
  • sp_xdetails
  • Performance Logging

Tag: deadlock

Single-Row Deadlock

By Vedran Posted on 2017-11-26 Posted in Data Engine, TSQL and SQL Client Code Tagged with deadlock, TSQL
Single-Row Deadlock

Introduction Demonstration of the smallest possible deadlock: only one statement, one table, one row. Without transactions (no BEGIN TRANSACTION). Even RCSI (Read Committed Snapshot Isolation) is turned ON to eliminate shared locks. Everything is “by the book” as Books Online …

Single-Row Deadlock Read more »

Copyright © 2025 Vedran Kesegic Blog | Powered by Responsive Theme
Visit Us On TwitterVisit Us On FacebookCheck Our FeedVisit Us On LinkedinVisit Us On Youtube