Using the IF-EXISTS-UPDATE-ELSE-INSERT pattern in SQL can create deadlocks unless transacted and/or UPDLOCK'ed (or MERGE/HOLDOCK).This pattern in code is a race condition. A good example here of the ...

SQL Server may throw exceptions due to an invalid context. Contention can also arise between cleanup and application code; concurrent operations result in resource conflicts. SQL Server's concurrency ...