I find that the reason why most people poo-poo xp_CmdShell is because they don't actually know how to use it correctly and safely and they also forget that only the...

Heh... "Normal".  I had to look that word up in the dictionary. 😀  I'm actually pretty happy with "my normal". 😀  It would be extremely boring for most others.

And I...

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

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