Skip to main content

New answers tagged

3 votes
Accepted

How does the arithmetic for how many bytes are saved by row-compressing a datetime add up?

Pay no attention to the documentation for datetime row compression; it's nonsense. I can only assume the author conflated several ideas about datetime storage, in memory and in persistent storage. The ...
Paul White's user avatar
  • 84.3k
3 votes
Accepted

Will NVARCHAR(max) columns benefit from row compression?

No. With row compression nvarchar(n) will benefit from Unicode Compression. But not nvarchar(max). Because the data is uncompressed, you can measure the storage size with datalength: select avg(...
David Browne - Microsoft's user avatar

Top 50 recent answers are included