title: Insertion and selection at same table at same time
body: <p>Since I am new to Sql server, Could any one please clarify on this ?</p>
  
  <p>Consider the case, </p>
  
  <p>I have a table <strong>"dbo.test"</strong> which contains 100 million records.</p>
  
  <p>10 select statement is running on the table <strong>"dbo.test"</strong>, each selection will return 1 million records. </p>
  
  <p>Now I want to insert 1 million records to the same table <strong>"dbo.test"</strong>. but I am not going to select the new data,(which I am inserting, I have filters accordingly).</p>
  
  <p>Here can I insert the 1 million, or need to wait for all select statements to complete.</p>
  
  <p>How about performance, if I start insertion ?</p>
  
  <p>Queries are welcome.</p>