• roger.plowman (1/30/2013)


    However, the question now becomes, why *doesn't* it compress seperately stored data?

    I started to reply here, but as the length of my reply grew I realised I probably better put it on my blog. So here is the link: http://sqlblog.com/blogs/hugo_kornelis/archive/2013/01/31/why-does-sql-server-not-compress-data-on-lob-pages.aspx.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/