title: Select Statement Is Causing Insert statement to block
body: <p>How Intended shared lock can impact inserts</p>
  
  <p>Hi All,</p>
  
  <p>i have gone through some blogs and find out that the Select statement (shared lock) can also block 
  the insert and update statement. i understand that this is true and i am try to replicate this.
  but somehow i am not able to replicate this. can anyone please help me to replicate this issue </p>
  
  <p>This is what i am trying to do </p>
  
  <p>Connection 1</p>
  
  <pre><code>BEGIN TRAN 
  Select * from myBigTable 
  COMMIT 
  </code></pre>
  
  <p>Connection 2 </p>
  
  <pre><code>WHILE (1=1)
  BEGIN 
      BEGIN TRAN 
          INSERT INTO MyBigTable(.....)
          SELECT ......
      COMMIT 
  END 
  </code></pre>
  
  <p>But both are running fine. can someone guide me on replicating this issue. </p>
  
  <p>Thanks
  Atul</p>