Handling huge amount of sql select data

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Handling huge amount of sql select data

Author

Topic

vishalchowdhary
Starting Member

9 Posts

Posted - 2008-09-09 : 20:00:08

Hi,
I would like to know how to deal with sql select query which returns gigabytes of data. Such a query really slows down the process.

I have a query which causes memory errors since it returns gb's of data.

Can anyone suggest some ways to get data quickly?

Thanks,
Vishal

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-09-10 : 09:22:43

return less data, through paging perhaps.

what's the point of returning so much data? Is this for display on a web page or some other purpose?

elsasoft.org