SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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. 


No comments.

Leave a Comment

Please register or log in to leave a comment.