I have a table into which over 100,000 records will be inserted on a daily
basis.
This table will have many indexes.
The records come from another SQL server table.

Whats the best way to insert these records into the SQL table?
How can i disable or ensure that the indexes will NOT slow down the INSERT?

LeAnne,

Try dropping the nonclustered indexes and recreating them after the load.


AMB

"LeAnne" wrote:

Hello LeAnne,

A lot of people remove indexes
Remove triggers
Remove users
Set the T Log to SIMPLE
Ensure adeqoate space in DB and log so we do not need to AUTOGROW


You can always change these back to the way they were afterwards.

When you say a lot of indexes? What do you mean?

Allan