Types of SQL Server Compression Used for MDF Database

sql database compression

Microsoft SQL Server supports different compression types for tables and indexes, and also supports archival compression for them. The data compression feature in SQL Server is very helpful in reducing the size of the database file. Additionally, data compression is helpful in improving performance of I/O intensive workloads because the data is stored in fewer pages and queries need to read fewer pages from disk.  Continue reading