Last Post 25 Apr 2002 08:06 AM by Noycey. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Noycey
New Member
New Member

--
25 Apr 2002 08:06 AM
Just a suggestion and not sure if it is possible to alter your app design but as you have removed all indexes have you thought about using fast BCP to insert your data into SQL Server? Instead of creating the insert strings, place the data into files and use the fast BCP utility to load data into your database, mess around with the options like batch_size to improve performance and rebuild your indexes once the process has completed.


Acceptable Use Policy
---