I would like to update the table in single run which has 500 millions records without lock table..
I had come up the below query but need to run many times and is slow..
UPDATE TOP(10000) SalesHistory
SET SalePriceIndicator = 1
FROM Sales WITH (READPAST)
WHERE SalePriceIndicator IS NULL
Please let me know if there are any better solution or query to update.
Thanks for your help in advance..