InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 23:27:04 GMT20http://www.sqlservercentral.com/Forums/Topic542523-145-1.aspx[quote][b]sabyasachi.mukherjee (7/29/2008)[/b][hr]We are loading about 1.8 million records from a flatfile. what should be the commit interval for loading this?[/quote]Depend on: what recovery mode you are using (you may want to switch to bulk during the load), how large the rows are, are you expecting any conflicts/ roolbacks, in case of rollbacks how much you would like to roll back, what is the size of your transaction log, how much it is growing, are you happy with the growth rate, is this happening during a busy/quiet period, ...Regards, AndrasTue, 29 Jul 2008 05:22:08 GMTAndras Belokosztolszkihttp://www.sqlservercentral.com/Forums/Topic542523-145-1.aspxWe are loading about 1.8 million records from a flatfile. what should be the commit interval for loading this?Tue, 29 Jul 2008 05:18:31 GMTsabyasm