If their plan fails, they can always go back to tipping Dogecoin or peddling courses on how to get rich quick by buying cheap stuff on AliBaba and reselling it...

There is...

Maybe so.  Can your chatbot make the case for it? ...

I wrote my own little dity.  Basically, it skips anything that has been rebuilt in the last 22...

Imo davidandrews13 has the right idea.  In SQL 2022

select string_agg(sv.[value], ' ') within group (order by sv.ordinal) first2_in_order
from #temp t
     cross apply...

I rebuild stats on a nightly database on two of my most active databases just about every night mostly out of paranoia because of all the bloody ever-increasing keyed...

Set up some test data:

DROP TABLE IF EXISTS #temp
GO
SELECT * 
  INTO #temp
  FROM (VALUES ('ABC Property Management Inc.'),
      ...

Look at the execution plan on both databases.

One thing you could check the location  of the TEMP and TMP environmental variables. If they are set to C you could change them to another drive with more space.

ChatGPT is DANGEROUS. It always produces results that seem plausible but can be entirely wrong. If you are lucky, it just won't compile. If you aren't it may destroy...

• This reply was modified 1 year, 8 months ago by  Jonathan AC Roberts.

If that's what is coming out of ChatGPT, then my job is still safe for the time being.

All 3 of CGPT queries are doing an update of the entire...

• This reply was modified 1 year, 8 months ago by  Jonathan AC Roberts.

You can get an answer to your question by just pasting it into ChatGPT:

Query 1:

UPDATE [SF_Title_Update]
SET [Title_Proper] = 
    CASE 
   ...

Please let me know how long the procedure takes with the updated SQL.

I corrected that in my previous comment.

;WITH CTE AS
(
    SELECT DISTINCT [VID],[OrdDate],[Prg1],[Prg2],[Prg3],[Prg4],[Prg5],[Prg6],[RowUpdatDateTime]
      FROM #new
),
CTE2 AS
(
    SELECT...

UPDATE t
   SET t.Title_Update = CONCAT(T1.Descr, T2.Descr)
  FROM YourTable t
 CROSS APPLY(VALUES (CASE
           ...