I've inherited a database on which a contractor was toying around with compressing indexes.
As the work she did was never documented I've been asked to remove all compression from the database so that the front end vendor can test a service pack.
Is there a simple way to either uncompress all of the compressed indexes within a database or to rebuild all existing indexes within the database without compression?
Thanks for your time,
View Complete Post