SELECT '1' AS 'CommitBlock',
       '1' AS 'EnforceTagExistence',
       (SELECT vw_deferments.loan_number AS '@loannumber',
    ...

I updated the procedure (for my purposes) so it doesn't attempt to update stats on the sys schema by updating one of the ANDs in the WHERE to include 'sys':

@jonathan-2... that will work if "any" of the 3 are present.  I'm thinking the OP only wants to exclude if all 3 are present.  But, please, let him explain...

Attached.  Again, I'm very aggressive in the code.  If the RowModCtr > 0, then I rebuild the stats.  You can certain modify that...

Dear ChatGPT

I have a table where it has id column, along with description.

Based on Group BY ID, I need to verify for each ID we have row exists with Description...

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 2 years, 6 months ago by Jonathan AC Roberts.