- Comparison : Comparing backups with and without compression
- Enabling Backup Compression by Default
- Backup Compression Optimizations
Table & Index Compression
- Table compression basics
- TSQL - Commands to compress database tables
- TSQL - Commands to compress database indexes
- TSQL - Compress all tables and all indexes (Original | Updated - 2016)
- TSQL - Compress uncompressed tables and indexes
- TSQL - List compressed / uncompressed objects
- TSQL - Minimising Compression Rebuild Time
- Paul Nielson's procs to estimate and perform table compression are here.
- Real world tryout (performance implications)
No comments:
Post a Comment