hI
I am moving huge volumes of data from a dbase file to SQL Server using DTS. The table into which the data is moved contains a clustered index and 2 non-clustered indexes. My problem is that the transfer is slow. The data is read fast enough but the actual transfer takes time. For example say if I am transferring
50000 records, the DTS reads 50000 records fast enough but gets stuck at 50000 for a considerable period of time before successful transfer of data. Is it because of the indexes?
But i cannot drop the indexes because they are required and recreating the indexes will again take a lot of time. Any solution for this particular problem will be appreciated.
Thanks
Start Free Trial
