The issue with using QUOTENAME is that it returns the result as an NVARCHAR(258).  The OP started out with a VARCHAR().

In this case, the resulting STRING_AGG() returns an NVARCHAR(4000).

Just "bumping" this because of the "1 Post on another Page won't display" problem that this forum has.  I really wish they'd fix this issue. 🙁

What did you change to make it so?

Heh... what?  You don't like using D1, D2, D3, D4, etc, for the names of cascading CTEs? 😛  Or, how about table aliases named T1, T2, T3, T4, etc?

I've seen...

Yes... there's a super easy way...

Not that the code is unreadable or anything like that but consider documenting your production code so people don't have to try to figure out what the intent of the...

hi Jeff, I think the problem was that I didn't restart the server after messing with the auto update stats and auto update stats async values. Without restarting the...

It would have been nice if you would have provided some links to the MS Documentation so people could easily find it to learn more.

So, I tried converting to "nvarchar(max)" and "varbinary(max)," but without success. Therefore, I had to resort to a more radical approach, which involved extracting data from the client's portal....

So Jeff,

this sounds like a dumb question, but how do I insert a blob (image/pdf/doc) into the table via the SSMS?  Do I need a CAST statement or an...

Using the following code (your code with some stats measurements added), I'm not seeing any updates to the stats on the 600 row run.

--SELECT 500 + (0.20...

This fixed the issue: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/install/windows/sql-server-upgrade-failed-error-15151 Thanks. I wonder would it be possible to use SQL Profiler (or XE) to find out this kind of issues? To detect the batch...

If doing what the error text you posted (checking the logs) brings no joy, I can think of no other recovery than to do restores from the backups of the...

I believe the latter that you mention is the only way.

I also want to warn than none of what has done (according to what you've described) will hold up in...

I'd need to see the execution plans to understand what's going on. Further, two different databases means, possibly, two different sets of data, two different sets of statistics, two...