Home Forums SQL Server 2008 T-SQL (SS2K8) Bulk insert slower after upgrade in SQL2008 R2 RE: Bulk insert slower after upgrade in SQL2008 R2

  • August 17, 2012 at 7:52 am

    #1527088

    I just did a select * from table in 2005 and 2008.

    2005 - it took 35 mins for 16 million rows

    2008- took 48 Mins for 16 Million Rows.

    I see comptability level is set to 100 in 2008. Will changing this to 90 help?