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?
sql
Insert or Update pattern for Sql Server
Implementing the UPSERT (insert or update) pattern in MS SQL Server can be tricky. In this post I explore the various advantages and disadvantages of various implementations.