SQL SERVER – Data and Page Compressions – Data Storage and IO Improvement
- by pinaldave
The performance of SQL Server is primarily decided by the disk I/O efficiency. Improving I/O definitely improves the performance. SQL Server 2008 introduced Data and Backup compression features to improve the disk I/O. Here, I will explain Data compression.
Data compression implies the reduction in the disk space reserved by data. Therefore, data compression can be [...]