Returning Results 1

[HRoarke]

Hi -

I seem to recall reading about a setting in SQL Server that causes, for example, a stored procedure to start returning results to the caller after the first N records are generated instead of processing an entire statement first. Unfortunately, I can't find any info in books online or MSDN. Does anyone have any info on such a setting?

Thanks in advance (and Happy Friday!)

"I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine."
— John Galt
Atlas Shrugged

If you want to get the best response to a question, please check out FAQ222-2244 first

 

[SQLDenis]

select * from authors option (fast 1)

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[HRoarke]

Cheers, Denis. Here - star for you.


"I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine."
— John Galt
Atlas Shrugged

If you want to get the best response to a question, please check out FAQ222-2244 first