I need to update the data of a table simultaneously from four different SSMSs. I have 100 million data, with one PK. I update different rows in order to avoid locking i.e. 1 to 25 million in first SSMS, 25000001 to 50 million in next and so on.
I used a loop to update 5000 records at a time in order to avoid row locks being escalated to table locks.
The execution time is not clearly indicating that whether the data is updated in parallel or sequentially. My question are: 1. Can we update data like this in parallel to fasten our process? 2. If not, is there any other method to do so as I have 500 million records in my table.