How to improve performance during Insertion
Here are the following guidelines to increase performance during INSERT operation: 1. Inserting data into a table with a single clustered index is slightly better than inserting the same data into the same table with a corresponding nonclustered index 2. If you are doing bulk copy of data, when possible, use the BULK INSERT statement instead of the bcp utility 3.
Read the original post:
How to improve performance during Insertion
Пожалуй, соглашусь. Хотя свои нюансы здесь есть. Полезная информация. Воспользуюсь.