Data Compression in Microsoft SQL Server 2008
Play Data Compression in Microsoft SQL Server 2008
Is your database big? Are you interested in reducing its size to half or even to one-third? The new release of SQL Server will provide you native data compression for your tables, indexes, and partitions that can significantly reduce the size of your database. A smaller database can lead to better performance for IO bound loads, reduce memory requirement and the manageability cost (e.g., backup/recovery) of your database. This session describes how SQL Server compresses the data in SQL Server and its impact on the workload. We also share the best practices and the lessons learned based on the feedback from early adopters.