Someone has to set the recovery model of the database. They don't change randomly. Now, if the full backup of a database was in a different recovery model than the...

Well, I hope you both get a little refresh going. I'm feeling a bit more on it today after playing radio all day Saturday (Tour De Tulsa, bike rides and...

Through SQL? No. It's a command line driven process. Powershell is how I would do it. Check out DBATools.

Were both these generated by ChatGPT?

The first question ranges all over the place. The first paragraph is all about performance, then the second is data analysis. Which are you really...

Why not take a backup, transfer that, restore it? I'm lazy too.

Just remember, Managed Instance is a SQL Server instance. The server aspects are gone, so no worries about that. However, all the internals are still there. So, database consistency, that's...

I don't have an answer or even a guess. Hang on though. I'll see if I can get some help.

What you're seeing there is the internal server name. It's not actually a database, but the VM on which your databases are running. I don't have all the internals access...

Instead of quoting the column names - I would recommend changing the names to something else.  For example:

plan_name instead of [Plan]

total_count instead of [Count]

total_amount_dollars instead of [Amount ($)]

Makes it...

Are there constraints on the tables you're inserting to? I'm with everyone else, not enough information to make a single suggestion, not even a guess.

So, I did a little experiment with ChatGPT. I'd strongly exercise caution using it.

Also, all previous recordings from all previous Summits are on Youtube. Well, all Summits that had recordings available. I think it only goes back a few years to 2017.

Be real, real cautious about using ChatGPT for any tuning advice. I was testing it out asking questions and it gets a lot of stuff badly wrong. I mean, very...

Here's all the recordings from the 2021 virtual event. That'll give you some idea. Otherwise, I'd suggest using the Wayback Machine and seeing if that shows last year's...

Several different things reset that information. It's part of why when someone says they're looking to remove unused indexes, I suggest caution when referencing that stuff as a way of...