Steve, why is it that code reuse in T-SQL, in particular refactoring, results in performance penalties? I'm ignorant as to why this is so. Just trying to learn more,...

Jeff M,

I can't stop laughing at your response.  You are correct that I am trying to leverage previous work done in the stored procedures instead of rewriting the logic...

And still no answer as the WHY this needs to be done.

Why don't you ask the folks at AWS?  And, you're making money at this, yes?

That actually looks and sounds like a precursor to SPAM, as has...

A secondary file  typically contains a subset of...

The issue is that they think that they want to stop using the STUFF method (which is really the for XML PATH concatenation) for some reason but won't explain why...

I have to ask... why are you duplicating more than a half million rows from a 206GB table into the SAME database???  If we knew that, we might be able...

Such workarounds are absolutely stupid.  Not because the workaround itself is stupid but, rather, because Microsoft has made such a workaround NECESSARY.

They release broken, only partially functional, and performance challenged...

Without some actual test data, all I can say is STRING_SPLIT() and CASE.

If you want a coded example, please read the article at the first link in my signature line...

From the Article:[hr]

"I have seen a few people call for raising the RAM limit in the Standard Edition of SQL Server. In 2016, Aaron Bertrand voiced this, and for 2019,...

It's not just you.  When the op comes back...

Same here even...

Hey all,

Sorry for asking so many questions, but I'm usually not able to easily find solutions to the problems I face. This particular problem is as such. I have...

Considering the leading "v_", those probably aren't tables you're dealing with.  They're probably views and the probably have some problems of the own that are at least exacerbating the issue...