title: Handling large SQL select queries / Read sql data in chunks
body: <p>I'm using .Net 4.0 and SQL server 2008 R2.</p>
  
  <p>I'm running a big SQL select query which returns millions of results and takes up a long time to fully run.</p>
  
  <p>Does anyone know how can I read only some of the results returned by the query without having to wait for the whole query to complete?</p>
  
  <p>In other words, I want to read the first by 10,000 records chunks while the query still runs and getting the next results.</p>