Today I asked the developer did you know you removed the no lock and now we have 10+ deadlocks a day. Response was deadlocks are the preferred method. What’s your comments on that? #sqlhelp

@SQLYard That you should look into the long running transactions being used by the apps/users, instead of slapping nolock on everything?

@SQLYard Yeah - deadlocks CAN preferable to inconsistent data - and usually are. And, IF you're seeing deadlocks, 'missing' indexes might help alleviate some of those, but - ultimately - those are a code/logic (order of operations) issue. period.