Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Best way to select a large amount of data? RE: Best way to select a large amount of data?
Steve Jones - SSC Editor
SSC Guru
Points: 734552
More actions
August 20, 2010 at 8:03 am
#1209671
5mm rows for a report is a little silly. There is no way anyone goes through this much data, even for an audit. And I can't see it being run very often.
I would look to clean this up from a business point of view.