asked
Effective way to compress NVARCHAR(MAX)?
I am trying to compress some tables that have `NVARCHAR(MAX)` fields. Unfortunately, the `row` and the `page` compression do not have the desire impact (only ~100/200 MB saved for 20 GB table). Also, I am not able to apply column store and column store archival compressions because they do not support compression of `NVARCHAR(MAX)` fields. Can anyone tell if I have any alternatives here? I also guess the `row` and `page` compression do not have effect because the content of the `NVARCHAR(MAX)` columns is unique.
This site functions according to votes. For all helpful answers below, show this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer.
With compression options (including columnstore) you are pretty stuck. LOBs are not supported for compression with the native process. You could try a SAN vendor that is MS certified for SQL Server that offers compression.
According to this BOL article, you can benefit from PAGE compression on nvarchar(max) in SQL Server 2014: [
http://msdn.microsoft.com/en-us/library/ee240835.aspx][1] [1]:
http://msdn.microsoft.com/en-us/library/ee240835.aspx
17 People are following this question.
