SSAS Tabular Compression of Binary and Flag fields
I'm currently doing some Tabular Cube design, and part of the design has to include several "Y/N" flag fields. My inner geek then wondered what, if any, difference the data type made to the compression rates of the cube. So, to start with I created a SQL Server table with three columns with the three usual types for this type of data
Read more...