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

Back in the day, before SQL Server 2012 was previewed, I worked on a project which started with a blank database.  My teammate at the time started sending me...

I've been a member of this forum for 17 years, mostly a lurker with very occasional posting or replying.  I am the baby Jeff at my company.  My scope...

😀