We have a performance problem when inserting many rows into a table that
already keeps a very large amount of data on an SQL Server 2000 system. The
table has four indexes (but no CLUSTERED).
Currently i am using an ADO Recordset Batchupdate but this has not been an
improvement compared with the previously used precompiled INSERT statement
using an ADO Command object.
A few day ago i tied to improve performance using the Index Tuning Wizard
but as a result our application was much slower than before. Tuning indexes
does not seem to be a solution.
Does anyone have an idea what can be done to improve the server performance?
Which is the fastest way to get a large amount of data into a table?
Thanks in advance