The Skinny on Data Compression
Download Demos
Videos
- Microsoft Certified Master Readiness Video: New Database Structures in SQL Server 2008 (the first segment is on data compression)
Blogs
- Bradley Ball (posting for SQL University) has three posts on data compression as part of their Fall 2011 semester.
- Jonathan Kehayias has a great entry on using Extended Events to track Page Compression operations.
- Brad McGehee posted an excerpt from his e-book that discusses both data and backup compression in SQL Server 2008.
- Brent Ozar takes a light-hearted look at data compression and gives a good reminder that compression is a journey, not a destination because it’s not inherited by newly-created tables or indexes.
- Paul Randal has a post with some good Q&A on both data and backup compression.
- Linchi Shea talks about how the distribution of data can impact the amount of compression you get.
- The SQL Server Storage Engine Team has an excellent series of blog posts covering many aspects of data compression.
- If you’re looking for a good way to keep index statistics (which can help when deciding what type of compression to use) I have a post on collecting long-term index usage statistics.
[…] Backup Compression 6 August 2013 by Bob Pusateri in SQL Server with zero comments When I’m presenting on SQL Server data compression, I frequently get asked if data compression and backup compression can be used together. I keep […]