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: 734489
More actions
August 19, 2010 at 4:06 pm
#1209411
Are you perhaps selecting columns you don't need? Or pulling back BLOB type data?
5mm rows doesn't seem like a crazy number. Are you sure the server is properly sized?