Beside creating proper indexes, developers also need to lock tables in the same order all the time to avoid deadlock situation.

Derek