• Another easy mistake to make is to put a clustered index on the view that conflicts with the clustered index in the base tables. I now hold the world record for the shortest time to create a deadlock.

    At least I got the chance to see some genuine output from the deadlock trace in SQL Profiles:-P