• The only problem with that is that in a real world scenario everyone will get different results. Depending upon the datatypes that you use, the free space in your pages and the like you will get differing amounts of compression and different performance gains/losses.

    Everyone needs to run their own evaluation, however it would be great to have a location where folks could put their real world examples (such as prior space utilization, prior performance, schemas, new utilization, new performance and a calculation of how much compression has improved (or degraded) their performance).

    From a community perspective that could really help folks make a slightly more informed decision prior to going through the work involved in testing it all out.



    Shamless self promotion - read my blog http://sirsql.net