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.



Subscribe to this blog
Briefcase
Print
No comments.