Is it possible to retrieve parts of the resultset from SQL Server queries in advance? For instance if I run a query that will return 20,000 rows, is it possible to throw the results in packages of 100 to the requesting instance (.net code for instance) and allow using them instead of waiting for all 20,000 rows to be read and returned?
A similar behaviour I have observed using SSMS: The resultset is filled ongoing even before the query is completed. Don't know if this is the same, but I am pretty sure if I run an SqlClient ExecuteNonQuery command, I would have to wait for all data being returned before I can fill e.g. a datagridview.
I do not know the ideal wording for this scenario, maybe this is the reason I can't find similar questions.
I have read about OPTION FAST that seems to have no effect. Does this really address the question?