To minimize deadlocks, you would refer to "Minimizing Deadlocks" in SQL
Server Books Online. In addition, some other suggestions to minimize
1. Use update locks when applicable. This reduces Conversion Deadlocks. You
can explicitly ask for an update lock by using the (UPDLOCK) hint in a
FROM Customers WITH (UPDLOCK)
WHERE Customer = 'Bob'
2. Create clustered index to distribute inserts across the entire table.
This ensures that the inserts are not happening on at last page ONLY.
3. Avoid placing clustered index on columns that are frequently updated.
Updates to clustered index ...