http://msdn.microsoft.com/en-us/library/cc280449.aspx
'''
EXEC sp_estimate_data_compression_savings 'dbo', 'sites', NULL, NULL, 'PAGE' ;
'''
Notes
- Datavalues table will compress well with ROW
- series catalog table compresss well with PAGE
- nvarChar/varChar are not compressed...
HIS central:
- use page compression
- from Sql Server manager, click on a table, and select storage, manage compression
- schedule a job to do this for large tables
ODM:
- use row compression on datavalues