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
Last activity: Apr 16, 2024, 06:22 AM