You could/should setup an Extended Event to capture anything (including code) that makes the log file grow.  Of course, you'd have to shrink the log file to a reasonable size...

You could/should setup an Extended Event to capture anything (including code) that makes the log file grow.  Of course, you'd have to shrink the log file to a reasonable size...

If I'm thinking the same way as you, just use SUM on each column with a GROUP BY on what you have in the left-most column.

Also, this isn't your first...

Sorry... not seeing any "sample...

Bumping the previous post so that it actually shows up because of the "first post on a page" problem they haven't fixed on this forum yet. 🙁

Yep, that's what I was thinking about. Thanks for clarifying! 🙂

I've had my head embedded in Postgres for the last few years. It's not surprising something got pushed out...

Post deleted.  Wrong spot for the post.

It's not your first visit here so you should already know that, if you'd posted the data in a readily consumable format, you'd have a code-tested answer by now. 😉

I...

With some good bit of work, the header version could be parsed but...

No.  It hasn't changed.  What it says in BOL has been true since I can...

maxdop is set to 1 at instance level and at database level it is set to 4.  looks like  each operator within plan is taking 4 threads

Just in case you don't know him, Eirikur is one of the contributors to the DelimitedSplit8K function. He made a simple but important change to it after SQL Server 2012...

I've heard such a thing many times.  The answer is always "No" unless you ask...

What is...

Testing complete.  Unfortunately, it made zero difference in performance.

Thank you both!

We had to upgrade because of "corporate policy".  We were at 2016.  2017 doesn't have the horrible performance issues that 2019/2022 has.  Even a super simple Tally function...