Home Forums SQL Server 2005 SQL Server 2005 General Discussion Inserting a 800 million records from Staging database to EDW, how to totally disable logging RE: Inserting a 800 million records from Staging database to EDW, how to totally disable logging

  • April 3, 2009 at 9:30 am

    #971674

    have you tried bulk logging? and make sure auto create and update statistics is off during the load. i've done replication snapshots of 300 million row tables and turning off the statistics creation and updates speeds things up