>I think if you try to apply passing a batch of, say, 10K updates at a time, you may save about 10 hours. Unfortunately, it's impossible to predict right now the exact save time. But I am pretty certain that there should be a significant gain.
>
>If you want to confirm my suggestion, you can ask your question in this forum
>
>
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=transactsql>
>There are several high reputable SQL Server MVPs which are frequently present and with luck you can get a good advice.
After more research, I have found the following:
If I send the updates one update at a time, I will end up in an average of 0.0156 per update.
If I send the updates 1000 at a time, I end up with a duration of about a second. So, that would be a gain in here.