29 Nov
2019
29 Nov
'19
2:46 p.m.
Another great tip! Dropping the indexes before adding records is a proven speed tip too if you can do it and then just re-add afterwards.
On 11/29/2019 4:48 AM, Alan Bourke wrote:
Is this a one-off data take on, or an ongoing requirement?
If you have the ability to do it, you might see an improvement by disabling all *non-clustered* indexes on the target SQL Server tables before doing your inserts, and then re-enabling them afterward.