[dba-SQLServer] Big db update

Stephen Hait shait at mindspring.com
Thu Aug 26 15:02:49 CDT 2004


> As you know by now I am working on a largish database, 65 million
> names / addresses plus demographics, ~600 fields it turns out.  Over

You most likely are already aware of this, but it's much faster to 
BCP in when there are no indexes on the target table - you can 
just build the indexes after the import.

Stephen



More information about the dba-SQLServer mailing list