title: SQL server concurrent accessing
body: <p>When sql server is receiving two queries (SELECT * From the_Same_Table), at exactly the same time, and if u have a server with multiple processors, Can sql server retrieve the data at the same time?</p>
  
  <p>I am trying to understand what will happen if a cheap select statement that finish within .01 sec, and 1000 users run the same query exactly at the same time.  I think what will happen that if the server is having four processors, then SQL server will serve the first four in .01 sec and serve next four users in 0.02 sec, extra.</p>
  
  <p>Is that even close to what will actually happen?</p>
  
  <p>I think I will try to use some kind of code and loggers to test that, or maybe there is reliable testing tools to do that.</p>
  
  <p>Thanks  </p>