SELECT Hints, Tips, Tricks FROM Hugo Kornelis WHERE RDBMS = 'SQL Server' : Compressionhttp://www2.sqlblog.com/blogs/hugo_kornelis/archive/tags/Compression/default.aspxTags: CompressionenCommunityServer 2.1 SP2 (Build: 61129.1)Why does SQL Server not compress data on LOB pages?http://www2.sqlblog.com/blogs/hugo_kornelis/archive/2013/01/31/why-does-sql-server-not-compress-data-on-lob-pages.aspxThu, 31 Jan 2013 09:08:03 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47406Hugo Kornelis10http://www2.sqlblog.com/blogs/hugo_kornelis/comments/47406.aspxhttp://www2.sqlblog.com/blogs/hugo_kornelis/commentrss.aspx?PostID=47406Enabling compression on your database can save you a lot of space – but when you have a lot of varchar(max) or nvarchar(max) data, you may find the savings to be limited. This is because only data stored on the data and index pages is compressed, and...(<a href="http://www2.sqlblog.com/blogs/hugo_kornelis/archive/2013/01/31/why-does-sql-server-not-compress-data-on-lob-pages.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=47406" width="1" height="1">CompressionInternals