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

  • I know this is an old post, but just want to add my two pence...

    Select into a a good option as it is minimum logged. Also break up your insert to align with target table partition which enable you to switch in the new partition after it is loaded and indexed. Then repeat the process for all other partitions.