Thanks....the 2 tables in question are pretty small and have same amount of rows in both UAT & PROD

I've updated the STATISTICS on both tables and waiting for user...

Obviously, two totally different subjects.

I rebuild stats on a nightly database on two of...

Sounds like a ton of fun.  When you did an index rebuild, did you rebuild it to a different file group and then delete the old file group to prevent...

While I applaud the technology, it's "just" a summation of common knowledge, which is frequently incorrect.  It also only provides one "opinionated and confident answer" rather than multiple...

changing page verification to checksum, widening a column, after an irregular large delete or update, after a sql version upgrade, controlling growth of a VLDB (even 15% fragmentation on...

I have to ask... what problem are you trying to solve here?

I have a process that uses 2 tables in PROD and it has been running slow in PROD.

The tables are identical in UAT and the process runs much faster...

Nothing.  The issue is "ethics" and Thom wasn't mixing the two concepts just because he...

Of course it just makes positive statements.  It is a bot, it is not introspective.  It is just an advanced tool.  As with any tool it is up to...

For question #1, just do a test.  I think that you'll find that the stats take a lot longer because Index Rebuilds only affect/rebuild the columns they actually...

I'm a little surprised nobody has pointed out one of the biggest problems with AI-generated code:  it can be flat-out wrong and give no indication of any uncertainty.

            
March 8, 2023 at 8:06 pm
            
#4158318

            
            
                                                
        

The mistake is using the generic ChatGPT for questions in SQL.  This version of the chatbot IS a rookie.  There is a version of CHATGPT trained specifically for programming...

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...

I copied and pasted just the phone number in question from the XML you posted and put it in the following code.  The "special characters" are an ASCII 160... which...

It could also have a default like GETDATE() or some other non-null, non-blank fixed value.  That's why I'm thinking that the folks that asked the question are the ones best...