I haven't done it, so there's that.

However, based on the documentation, yeah, it should be possible. That's not saying it is. But it really should be.

I'd suggest a few more,...

Every single test I've seen over the last, almost 20 years, suggests, with the exception of Columnstore indexes, REORGANIZE is a complete waste of processing power and time. Just don't...

Prepping non-production environments can be a lot work. Script the heck out of it. And yeah, there is a command you can use, SHRINK. I don't recommend it for...

With size based cleanup set to auto, it'll ignore the 7 day limit and clean up the data based on the size.

EDIT!

But, if it doesn't hit the size limit, then...

• This reply was modified 3 years, 6 months ago by Grant Fritchey.

#SQLHelp is pretty much what it says, "Hey, I could use some help on SQL Server." And that's all it's for. Yeah, sometimes people try to use it advertise a...

Are you sure about the "normal people" part? I mean, that group of speakers includes me, so...

Ha!

I believe this stuff, communication with humans, is just hard. We all struggle. Fact...

It sounds like you're describing Database DevOps. Basically, code goes into source control. You can run a linter through it there, or automatically later. Set up continuous integration to...

Nice one!

Welcome, again, to the team. Great to have you here.

I'm a fan of C#.

You can download a copy of SQL Server Developer Edition for free. Or, better still, install Docker and simply get a SQL Server container, no installation required. Then, take a...

You have a couple of options, neither of which is straight to a table.

First, you can output a text only execution plan. No XML. No graphical whatever. You can then...

Unless you're simply building dynamic SQL on the fly, 100%, there's no way to do this in PostgreSQL. If you choose to do dynamic SQL, understand, depending on what and...

I think you're going to have to build a service on your own. I'm not aware of a cross-database service like this, let alone on AWS.

Thanks @rod and @tom

Nice piece Grant! My thought is that there is always something to be learned, knowing two languages might help in learning the third one, chemistry and physics can aid...