May 2000
Despite your best efforts and SQL Server 7.0's improved transaction contention management, you can't always avoid deadlocks, particularly when multiple indexes exist on a table. Use these tips to determine the best workaround for your situation.
SQL Server Magazine