Philip Semanchuk wrote:
... If you're doing a mass insert to populate a blank table it also often helps to postpone index creation until after the table is populated....
I forget the name of the SQL Server bulk loader, but for large loads, I used to populate a fresh table with the bulk data, then do UPDATEs and INSERTs to get the data spread out into the main tables. You (the OP) might try a scheme like that. --Scott David Daniels scott.dani...@acm.org -- http://mail.python.org/mailman/listinfo/python-list
