Writer: Sanjay Mishra
Contributors: Marcel van der Holst, Peter Carlin, Sunil Agarwal
Technical Reviewers: Stuart Ozer, Lindsey Allen, Juergen Thomas, Thomas Kejser, Burzin Patel, Prem Mehra, Joseph Sack, Jimmy May, Cameron Gardiner, Mike Ruthruff, Glenn Berry (SQL Server MVP), Paul S Randal (SQLskills.com), David P Smith (ServiceU Corporation)
Published: May 2009
The data compression feature in the Microsoft® SQL Server® 2008 database software can help reduce the size of the database as well as improve the performance of I/O intensive workloads. However, extra CPU resources are required on the database server to compress and decompress the data, while data is exchanged with the application. Therefore, it is important to understand the workload characteristics when deciding which tables to compress. This white paper provides guidance on the following:
For more information, please refer to the whitepaper Data Compression: Strategy, Capacity Planning and Best Practices.
Nice work on this, Sanjay.
Data Compression: Strategy, Capacity Planning and Best Practices Hot off the presses, the SQL CAT team
Pingback from SQL CAT New Whitepaper: Data Compression: Strategy, Capacity Planning and Best Practices by Sanjay Mishra, et al. | Coded Style
Shrinking a database with PAGE compressed heap removed PAGE compression from the heap -> Fixed in Cumulative update package 4 for SQL Server 2008 and SQL Server 2008 Service Pack 1.
Link to KB article: support.microsoft.com/.../963658
Pingback from Brent Ozar’s Reading List for MCM « SQL WARRIOR SPACE
Pingback from @MS_SQL_Server whitepapers New Path to Microsoft Certified Master: Microsoft SQL Server 2008 | sqlmashup
Pingback from New Path to Microsoft Certified Master: Microsoft SQL Server 2008 « SQL Consulting