29 Nov
2019
29 Nov
'19
9:48 a.m.
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.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm