DaveWentzel.com            All Things Data

compression

 

compression
2008 has new data compression options.  Some details:
  • MS is stating you can do this on a production database, if desired.  Might be better for development or for copies of large databases you need to test things like data porting against...and you don't need some of the larger tables but don't want to purge them due to FK
  • has an "estimate" stored procedure to tell you what the approx savings are
  • you can compress at the PAGE or ROW level (need to research this further). 

 

Version Specific Topics

Performance Page

DBA Topics

Add new comment