An Update To My Previous Post

,

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. 

Rate

Share

Share

Rate