I'll likely be alone on my take on this but "It Depends" on a whole lot of things.

When I first started at a company that I do work for, they...

Heh... not bad for something that used to be natively available on the f4 key until they came out with SQL Server 2005. 🙁  What a bummer that was (and...

Have you considered just making a large test table and testing it?

As a bit of a sidebar, I've not found any performance improvement that I can relate to the "new" CE but have a whole bunch of slowdowns that I can...

You can also add a computed column to the table - but I really don't see the need or requirement to create a column with multiple names.  It is...

Not if you understand that each row is unique and can have only one rate.  Either convention is just...

Hi

I have dataset like this

drop table if exists #dataset create table #dataset(CIF VARCHAR(255), PARENT_CIF VARCHAR(255), UP_CIF VARCHAR(255))

INSERT INTO #dataset SELECT 45218547, 54044082, 54044082 union all SELECT 54044082, 64349595, 64349595...

😀

It would appear that the author of the article has left the building. 🙁

This isn't quite correct - neither CTEs or Views are executed (materialized).  Both will be incorporated into the outer query - and then the execution plan is generated.

Now, if...

Thank you for...

p.s.  CTEs are inherently NOT reusable anywhere except the query that they live in.  They can be referenced as many times as you need to with the understanding that they...

Back to this older thread of "Can data save the world" and seeing what has been going on with the "climate change discussions" (and I hate to call it that)...

If you know the SPID for the query, you could also query the following DMV.  Look for the word "memory" in the documentation.

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-requests-transact-sql

So - going back to the OP's original post we see that a string that is greater than 8000 characters gets inserted with truncation and is successful for columns...