wayne: that is very handy bit of sql

it is impossible / unreasonable and unnecessary to stop all deadlocks

as long as there is correct retry logic

they are irrelevant

if you have an application with no deadlock handling

then you can add the deadlock retry in to the SPs with try catch