Defeating deadlocks with READ_COMMITTED_SNAPSHOT isolation
I was recently asked by a client to look into an issue they were having with a WCF web service. The application was generating a large number of errors, filling a 5MB log file every 5 minutes, and the performance of the...