title: Transaction deadlock for select query
body: <p>Occasionally, I have the following error for a stored procedure which is only a Select query: <code>Transaction (Process ID 91) was deadlocked on lock</code></p>
  
  <p>My initial understanding was that a select query won't lock a table, or won't cause a deadlock even if the table it tries to query is being updated/locked by another process, but it seems that a select query can cause deadlocks as well.</p>
  
  <p>If I set the isolation level to read uncommitted for the query, will that solve the problem?</p>