Microsoft® SQL Server 2012 Unleashed

Application Design Guidelines

Locking/deadlock considerations—These considerations are often the most misunderstood part of SQL Server implementations. Start by standardizing on update, insert, and delete order for all applications that modify data. You do not want to design in locking or deadlocking issues because of inconsistent resource locking orders that result in a “deadly embrace.” For a more in-depth discussion on locking and deadlocking and recommendations for avoiding locking performance issues, see Chapter 33.

Stateless application design ...