Hi there,
sql server has the ability to compress tables. Either row or page compression.
I did some testing with the 8MAN database and I have reduced the used space from almost 80% to 40%.
Attached is the t-sql script. It runs as daily job to compress the new tables. Currently I have only compressed the tables
in the fs, dw and tracer schemas with an row count larger than 500000.
If you set debug to 1, the script will not compress rather check how much compression would be possible and print the results.
Uploaded new version. Now it works, definitly.
Happy compressing!
Allmecht