Thanks for the reply.  I do use -c.  However, that is what is interesting.  When I run the query manually in SSMS, the output is all on one single...

Lordy... CodeProject just published a very interesting AI incident.  Here's the link they published.  Pretty spooky and seriously concerning stuff, IMHO.  Watch your kids, folks.

https://www.bbc.com/news/technology-59810383

Heh... smells like another prelude to SPAM.  For example, why would anyone in their right mind migrate a decade old version of SQL Server to brand new hardware?

Heh... <sarcasm = on> It's a "managed instance"... there shouldn't be any disasters, right? <sarcasm = off>

Considering the differences of the cloud providers and the different plans they all have,...

I want to know why you want to avoid STUFF.  What is the reason for such avoidance?

And as several have stated, STRING_AGG() didn't come out until 2017.  If you really...

Yeah... that "Do Not Call" registry doesn't work.  People and companies basically ignore it.

I sent you a PM here on the SSC site.  YOU NEED TO READ IT NOW!

Heh... one of the companies I do work for insisted that they wanted to move their heavy import, validation, and distribution system to Red Shift.  I asked "Why"?  They said...

The other indexes weren't fragmented so no need to rebuild all the indexes.  That's expensive even on such a small...

Here's what everyone seems to forget when downloading and using such code... 😉

--===== Check for Fragmentation on the Clustered Index
 SELECT  avg_fragmentation_in_percent
    ...

A lot of the department stores in the U.S. used to have a special "shop" in the store that would do that... sometimes, for free.

Glad it helped.  You helped a lot by posting readily consumable data.  Makes our "job" a whole lot easier and enjoyable.

Thanks Jeff,

I was hoping you might come along if I mentioned SET BASED in the Title/Tags 🙂

That's exactly what I needed, not too much editing for me, and a...

p.s.  We did do something great on this thread... although it's gotten a bit confrontational, it IS bringing a lot of things to light that people might not have known...

I do use that.  It's a part of...