[dba-SQLServer]Large recordsets

Erwin Craps Erwin.Craps at ithelps.be
Sun Nov 23 14:31:59 CST 2003


Martin,

Your question is not very clear to me.
What is it that you want to do?
I don't see what the prob is with "only" 50.000 records.

Erwin

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin
Reid
Sent: Sunday, November 23, 2003 9:03 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer]Large recordsets

I have to return perhaps in access of 50,000 records for use in Access.
Linked to SQL Server 2000

What would be the fastest approach to take.

Comments appreciated.

Yeah I know the obvious, filter them first. But for the moment I am not
allowed. to.


Martin

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



More information about the dba-SQLServer mailing list