I'm viewing this thread to educate myself on how to identify and resolve deadlocking. The links provided are great but for older (2005 and 2008) versions of SQL Server.
(1) Can you recommend a more modern link (for SQL Server 2008 / 2012) that you've found to be the current 'Bible on deadlock troubleshooting'?
(2) Is this still true:"They can generally be resolved by changing application or stored procedure code to access tables in the same logic order, or by changing the actual database schema or indexing structures. The first step in Deadlock elimination is to identify what two statements are actually causing the deadlocks to occur."
Thanks in advance.