• If you are attempting to insert data into a table with a clustered index you have to bear in mind that the data has to be moved about a lot to maintain the integrity of the index. I would recommend dropping the clustered index before the insert and then creating it again afterwards, you should see a noticeable improvement in the performance.



    Shamless self promotion - read my blog http://sirsql.net