• Perry Whittle (1/22/2014)


    SQL Server data compression would be my preference over NTFS compression

    + 1

    You can also make sure that your read only files are mostly full. I saw a technique for creating a new filegroup, rebuilding the clustered index to that filegroup and shrinking to just the size needed. If that's the only operation in that filegroup, you shouldn't get fragmentation.

    Other than that, you need to decide if the CPU tradeoff is worth the space saved.