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?

  • 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?