We were using %NOLOCK while retrying the update query.
The problem is that ProcessedCount differs when the pool size is set to 1 compared to when it is set to 5.
- Log in to post comments
All
Accepted answers
We were using %NOLOCK while retrying the update query.
The problem is that ProcessedCount differs when the pool size is set to 1 compared to when it is set to 5.