I mean it sounds like it has performance benefits in some specific scenarios, so that's cool. But I'd argue if someone has the same blob of text stored in many rows in their table, perhaps there's an opportunity for normalizing that field out into a separate table so it's not repeated. Then UPDATE performance probably won't matter as much.
I just asked a question What columns are needed to list the database, schema and table a record comes from? which asks about which database row comes from in a cross database/schema question and couldn't use database as a tag.
What is the appropriate term for that?
@SeanGallardy and to be fair to the OP (which does not come naturally), it would be an extremely well-specified question that included masking on tables not involved in the problem query
Now you all know what it's like working with the same people who say, "It took MS support 3 months". Clearly that's not every time, but many of the ones that ran long (for me and those I had to look over) it was the customer not able to give/get data or just stating it only happens every 90 days and they can't repro
I'm especially not happy about the severity stuff, people can just choose to have something labeled high severity and MS's stance is someone must be on the call at all times
so then you end up having half your people tied up on "high" severity cases which are not at all high severity
"we're justifying the business impact and severity of this case because the person who is working on this is going on vacation tomorrow and we want it done today."
"Does it affect production: No Are you down or unable to process: No Is there a degradation of service: No"
Again, TBF, MS has trained people to use high severity because of the staffing issues and that was the only way you could get someone to work on your stuff. That was also back in 2012-2014.
On a different note, why do people select the result of a huge query into a new temporary table and then immediately select * from temp; without doing anything else?
I mean, what's the thinking there
Except, "someone told me to use temporary tables to optimize our queries"
My attention was drawn to just such an incident just now by an "excessive comments" automatic flag
So I was already in a bad mood before I started reading the questions and endless commentary
And having ploughed (plowed) through all that, I am now too depressed to answer the question