@alan Thanks Alan
The Paul White post is great! I learn something every time I post in this forum. I am going to setup a test using your example with make_parallel.
@mm Thank you also MM
The technet tip is also good and might explain why the update might always be serial.
I have the task of running multiple updates to a table with a row count of 107 million. Even after splitting the table in to smaller tables (about 38 million rows ea) the updates are still very time consuming.
I thank you all for your help.
Doug