Data compression analysis, estimation, and implementation scripts.
Lists all objects (tables/indexes) that currently have data compression enabled (ROW or PAGE) with details on index types and partitions.
Comprehensive database-level compression analysis using cursors to estimate benefits for all tables/partitions with error handling.
Batch analysis of compression benefits across all tables in database, showing current/compressed sizes, gain percentages, and total potential savings.
Estimates compression savings for a specific table's indexes by comparing current vs. compressed sizes and calculating potential space reduction percentages.
Identifies uncompressed objects and generates ALTER statements to apply ROW compression with configurable options for online operations and MAXDOP.