Please note that the code pattern used here has a severe performance problem.
See https://www.simple-talk.com/content/article.aspx?article=2280 for explanations and options to fix

Please note that the code pattern used here has a severe performance problem.
See https://www.simple-talk.com/content/article.aspx?article=2280 for explanations and options to fix

http://www.sqlservercentral.com/stairway/72399/
http://www.sqlinthewild.co.za/index.php/category/sql-server/indexes/

And that's just the first two that came to mind. Spend some time with your favourite search engine and do some reading.

Without DDL I can't write the query...

Calculate a row_number over the partition and order that you want for the sum. Do that in a CTE. Then join that...

The problem, I suspect, is that log flushes are synchronous. The log has to be written in order, so with 1000 flushes a second, even if you had a 1ms...

Please don't start multiple threads for the same problem
https://www.sqlservercentral.com/Forums/1893974/PLE

Increase PLE: Add memory or reduce need for memory by tuning queries or reducing data. It's not complicated.
PLE is the measure of how long a page will stay in...

Why? If the CTE works, why not use it?

You can do the same thing with a subquery, but it might be harder to read.

Nothing I said is affected by isolation level.

Every time LineNo resets to 1 (as ordered by recid), you want the chunk number to increase by 1.
Is that a correct summary of the requirement?