title: NHibernate or SQL Server 2005 Regarding Max Results
body: <p>Is there a way to query Sql Server 2005 and return out of a 100 records. 
  Records 10 - 20. In other words only 10 rows would be returned. Not the first 10 but the second 10 - 20. </p>
  
  <p>I want to do this in TSQL. This would also be acceptable with NHibernate but ultimatley NHibernate would need to convert the HQL into TSQL. I know its possible to do this from Linq but I want to know whether its possible from TSQL.</p>
  
  <p>Oh btw. This is for optimization purpose. So just like you would return the Max 100 rows. You would return it for the same reason but a subset. Performance is the reason!!</p>