September 5, 2016 at 1:51 am
Thanks Andy! No Points for me, but getting a reason to read up on sparse columns and their limitations is much appreciated.
Sql Server blog: http://www.tsql.nu
September 5, 2016 at 3:56 am
Interesting to know that sparse columns aren't compressible. Thanks for the question.
My first thought was "every datatype"? Wow. Does that include every variation of datatype like char(1)...char(8000) . I realise blobs and the like are stored off row and can be on the file system so aren't a complication with compression, in fact aren't compressed, but surely having every other datatype would push your row over the 8000k limit and compression would fail for that reason. In the BOL notes it specifies 8060 because there's overhead for compression, which interestingly uses the same packing as a varbinary, which is now deprecated because row compression achieves the same outcome. Interesting the weird things you learn in QOTD, so thanks.
September 7, 2016 at 6:46 am
Excellent question as always Andy.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply