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
Dean.chetty
SSC Rookie
Points: 27
More actions
April 14, 2010 at 6:38 am
#1151287
Hi,
Not too sure if switching off the "auto stats" solved your problem.
One of the techniques that we have found useful is to batch inserts, updates and deletes.
Dean