We already keep 1 month of backup on drive and anything above that should transfer to shared backup network and that is the requirement...

It's really stupid... they all look like good ol' fashioned Arial with slightly different spacing.  Heh... you can change the package but it's still the same ol' Ritz.  No wonder...

Good lord... the things MS spends money on.  This seems a bit ridiculous to me especially when there's still so much in the product that needs to be fixed.

https://www.theverge.com/2021/4/28/22407297/microsoft-office-new-default-font-2022

First of all, those are...

First of all, those are NOT random deletes.  They're...

How massive are your DELETEs?

Probably it would be easier to copy the remaining part of data to a new table (exact copy of the old one) and then...

Presumably that 147GB CI had (nearly) every page out of logical order or (nearly) every page was below the fillfactor. Hmm, veryh odd, interesting.

Again, I can't imagine needing...

It does, indeed.  Thanks for the feedback.

As a bit of a sidebar and especially since the partitioning is done on a temporal column, consider a...

I'm just curious... Do you ever do SELECTs from this partitioned HEAP?  Do you ever UPDATE any of the rows in the HEAP?  What's the HEAP actually used for?  It...

I still have to disagree on REORG if: (1) you can't use online rebuilds AND (2) the table has some serious fragmentation you need to address AND (3)...

Based on To cool datacenter servers, Microsoft turns to boiling liquid => 3M Immersion cooling for data centers, it sounds like it's one of these: Fluorinert™...

Ah... gotta be careful even with those conditions.  If you can tolerate the extreme log file usage on such things (the 147/227GB table I cited above was fragmented only my...

REORGANIZE...

There aren't many types of fluids that have the behavior described in the article.  They usually fall into the general category of "Refrigerant" and most of those are pretty nasty...

Does that one...