Skip to content

Sam Saffron

Writing about software, performance, Ruby, Discourse, and technology.

  • Discourse
  • Ruby
  • MiniProfiler
  • SQL
  • AI
7 min read

Deadlocked

In SQL Server a SELECT statement can deadlock against an UPDATE statement without being in a transaction. Why does this happen? What is a good approach to SQL Server deadlocks?