Guidelines for minimizing Deadlocks in SQL Server

• User resources in the  same sequence in all transactions
• Shorten transactions by minimizing the number of  steps.
• Shorten transaction times by  avoiding queries that affect many rows.
• Set the DEADLOCK_PRIORITY setting to low.