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...

SQL 2022 will give you batch mode execution plans on indexes that are not columnstore, even if batch mode execution plans are slower.

Did you look at the execution plans...

@lisa,

My whole point is that the use of a function for such temporal range labeling is actually easier for the users to use because they don't need to us a...

Oh my.  I can only imagine.  Any chance of you sending an email about that?  I'm just...