SQL Server Deadlock Free!
Posted on 2009-12-30
I'm a seasoned enterprise app developer and have done a fair amount in the SQL Server realm. I'm tasked to rebuild our existing SQL schema and eliminating deadlocks is a high priority. The new schema will use numerous concise SQL procedures and the update volume will be high. What's the best way to ensure that deadlocks don't ocurr, and if they must, resolve themselves?