I have picked Row compression and moved it out of [Primary] and into its own FileGroup and .NDF file. I’ve been monitoring it this week and it’s been looking good so far. *Knock on wood*
I have started on another large table and have chosen Row compression due to constant inserts and updates. Partitioning was a consideration, but I was given the green-light to delete old data which will significantly reduce the size of the table and indexes.
That’s about all there is to update on this journey.