Or, don't rebuild the indexes at all. Find a good fill factor, set that, and leave them alone. Just maintain statistics.

Different rules for columnstore indexes though.

Strong recommendation: work backwards.

Figure out what it is that you need to deliver. Then, get a set of scripts together to deliver it, that doesn't involve using a cursor. That's...

I'm sorry, but I don't recall 2019 being a big mess. Most of the people I know who upgraded to it were happy. Were there issues? Sure. As with anything....

Probably not. Data modifications have to go somewhere to be persisted. That's locally. As the amount of data you modify grows, more and more data is stored locally. Now, you...

No. If you have size cleanup enabled, it'll clean up when it runs out of room, not wait the 7 days first.

You get a time-based cleanup and a size-based cleanup....

Since you can do a backup and a restore, you can do log shipping. If you're looking for a way to do this to MI with minimal downtime, that's generally...

No matter what, you'll have to do data cleansing, scripts or tools, that much is necessary. Generally, following data cleansing, I rebuild the indexes and then shrink the database, to...

I'm with Phil, probably your best bet is a trigger. Here are the docs. You want to look at the DML triggers and, probably, an AFTER trigger, meaning, after...

• This reply was modified 2 years, 10 months ago by Grant Fritchey. Reason: forgot url

The one I've been basing my own advice from is years old, by Brad McGehee. Frankly, I did a search, and I can't find it. That stinks, because lots of...

If you're going to run on AWS, I'd start by experimenting with AWS RDS. See how that works for you....

Ahhhh.... PLE.

I'm to the point where I actively dislike this metric. Not because it's problematic in and of itself. Instead, because of that doggone perpetual bit of "knowledge" that your...

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 2 years, 10 months ago by Grant Fritchey.