Hey Grant,

Thanks for the reply. I'm not upset (was just a bit surprised) and glad you aren't either. No harm done on either side then.

Looking back at the DBA thread,...

<sigh>

So I post a comment over at DBA Stack Exchange, because I know what I'm posting isn't an answer. I get dinged for it because it almost reads...

Based on https://docs.microsoft.com/en-us/archive/blogs/craigfr/query-plans-and-read-committed-isolation-level by Craig Freedman of Microsoft.

It would have been nice if you had acknowledged that.

Only committed data is read in the example shown.

There is no guarantee under locking...

I just came across this article. Nice work, Jeff 🙂

This hadn't occurred to me as a side-effect when I wrote the articles you linked to in the main text.

Cheers!

As you know, the essential difference with minimal logging is that SQL Server does not log individual rows - it logs at the page and extent level.

For log...

Perry,
Thanks for the suggested edit on dba.se but we cannot accept answers in the body of a question.
I'm not sure it makes sense to reopen the old question...

Contributing a couple of observations:

Nothing changes 🙂

ChrisM@Work (6/30/2015)

---

If you remember a year or four back when quite a few of us were messing around with rCTE's and figuring out what they were good for, I remember...

Jeff Moden (6/28/2015)

---

While I absolutely agree that (especially with a RBAR-like rCTE that counts) single rows are processed through the Table Spool in this case, a logical read is still...

The reason I often refer to logical reads of worktables (including spools) being measured in rows rather than pages is an aid to understanding for people who are confused by...

Another unfortunate aspect of the XML splitter (aside from barfing on certain characters, and being intellectually offensive ha ha) is that it may perform much, much worse than you would...

Jeff Moden (10/28/2014)

---

[...]The way to prevent the problem of someone missing the "column shift" problem if someone changes the underlying table is to create the table using WITH SCHEMABINDING...