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 underlying database was so bad that a simple query such as: SELECT COUNT (*) FROM Address would take up to a minute and a half to return. Checking the