>Craig,
>
>>Memory structures are different for arrays than cursors. I agree, that with a large array, paging could occur. But I think it is more likely to occur with a cursor because of the way they are managed.
>
>AFAIK, cursors (IF NOT FILTERED) are always stored on disk,
Nope. if not filtered, cursors could be totally stored in memory.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer