Blog Post

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

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating