If I decided to enable page/ row compression for few of our huge table,what other side factor I have to take consideration ?
: CPU usage ? how this will impact other session performance ?
: Backup and restore ?
: Mirroring or replication or even log shipping ? any concern ?
: Memory consumption especially in Buffer pool area ?