Deadlocking and SQL best practices:
Deadlocking refers to the condition in which one resource is waiting on the action of a second, while that second action is waiting on the first. This is different from being blocked, or having to wait for a resource. Using the locks above, if a transaction had a shared lock, then [...]
Filed under: SQL Deadlocking | Tagged: MS SQL Deadlocks, NOLOCK, PAGLOCK, ROWLOCK, Solve Deadlocks, SQL Best practices and tips, SQL Deadlocking refers to the condition, SQL Deadlocks, SQL Locks, SQL Tips, SQL Tricks | Leave a Comment »
