Sample Header Ad - 728x90

Will NVARCHAR(max) columns benefit from row compression?

0 votes
1 answer
118 views
I have a table that I believe owes most of its size to a huge NVARCHAR(max) column. I do not know how to test where most of its size comes from. Regardless, would such a table benefit from row compression? Or is NVARCHAR(max) already variable-length in such a way that row compression is guaranteed to do nothing?
Asked by J. Mini (1235 rep)
Apr 15, 2024, 06:37 PM
Last activity: Apr 16, 2024, 06:22 AM