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

@lalitprg2017 ,

More proof of what I was talking about for the "Readily Consumable Data" thing.  Two other folks saw a pattern that I'd missed and could easily test their solutions...

Assuming the pattern in the sample data is actually representative of your production data, the following would be simpler and more efficient as it eliminates the need to unpivot,...