If you are using SQL 2005, you can use SNAPSHOT ISOLATION MODE to reduce a probability of lock/deadlock problems. It is much better then desparate (NOLOCK) hint everywhere I found...