To enable the Single Row Mode add CURSOR=SINGLEROW to the Extended Properties of the connection string (in linked server - Provider String).
This mode could be used for ETL, Analytics, etc., basically for any scenario where forward-only cursor is needed. It allows processing of extremely large record sets (over billion records).
For more details refer to the Developer's Manual (available from the Download page).
