Updating a row in sql server 2016 guys dating girls taller than them
We have discovered that a couple of years ago a value was incorrectly altered and has subsequently made all following values incorrect.I have inherited a formula that uses the previous date to calculate but there appears to be dates missing in the table and at this point the formula stops.I am going to update the table Cust Transaction using a row by row method with a loop.
This will create a table and insert 1 million rows.Also, long running updates can cause blocking issues for other processes.Another approach is to update the data in smaller batches.You can set your own batch size after analyzing your data and environment to see what makes the most sense.
Another option for batching updates is to use the top statement for configuring the batch size.
The Cust Transaction table has 1 million rows and this took around 22 minutes to update all rows.