title: SQL Server Deadlock with Transaction Isolation Level Read Uncommitted
body: <p>I am getting this deadlock even though I set the transaction level to uncommitted.  Is there something I am doing wrong? I thought I was suppose to get a dirty read here.</p>
  
  <pre><code>SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
  
     SELECT 
              DISTINCT 
              venueCourt.Id, 
  </code></pre>
  
  <p><strong>Error</strong></p>
  
  <pre><code>System.Data.SqlClient.SqlException: Transaction (Process ID 73) was deadlocked on thread | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
  </code></pre>