The SQL Server Query Hint for the FAST number rows
Tradeoffs are at the heart of any query suggestion; often, you are sacrificing something, like flexibility, in order to increase consistency or a very particular performance attribute. When delivering code results, for instance, you might want to view the data right away, even before the entire set of data has been delivered.