Data compression

[peac3]

Hi guys,

I have a table which some of the columns contain so many NULL value and I was thinking to do compression for this table to save some space.

After I did some reading, the compression can reduce the performance quite some.

Have you guys done compression before and share the experience?

What is better one, row or page compression?

Thanks,

 

[simian336]

Why would you want to compress null values? In that case, any performance hit would negate the benefit.

Simi