title: SQL Server deadlock between two update statements
body: <p>I have a website that has a very popular forum on it and occasionally throughout the day I see several deadlocks happening between two identical (minus the data within them) update statements on the same forum. I'm not exactly sure why this is happening on this query as there are many other queries on the site that run with high concurrency without issue.</p>
  
  <p><img src="https://i.stack.imgur.com/WODlP.png" alt="Update Deadlock Graph"></p>
  
  <p><a href="https://i.stack.imgur.com/WODlP.png" rel="nofollow noreferrer">Full Image</a></p>
  
  <p>The query between the two processes is nearly identical, the graph shows it as:</p>
  
  <pre><code>update [Forum] set [DateModified] = @DateModified, [LatestLocalThreadID] = @LatestLocalThreadID where ID = 310     
  </code></pre>
  
  <p>Can anyone shed any light on what could be causing this?</p>