Problem with compression
I have run the following with nowrite:
compression set to 0 it is showing data size of 5.9GB, compressed data of 6.4GB and takes 84sec
compression set to 2, compressed data of 5.7GB and takes 677sec
Why would this database not be able to be compressed and why would the compressed size be greater than the data size?
Any help appreciated.