Good summary. Thanks for taking the time to do the experiments and to write up your conclusions.
Shifting gears a bit, I can't speak for anyone else but I rarely take anyone's word/test results for things having to do with performance in general or any type of disk compression techniques. Perhaps I missed something somewhere but it would have been real handy to have placed a test table generator in the Resources section of an article or provide a URL to download the test data or something to make it so people can more easily repeat your tests on their own. As it is, we can't even tell what the cardinality of each column is, which could certainly have an impact on such things as compression and Columnstore.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
"If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
"Change is inevitable... change for the better is not."
When you put the right degree of spin on it, the number 3|8
is also a glyph that describes the nature of a DBAs job. 😉
How to post code problems
Create a Tally Function (fnTally)