Summary
Data compression was the sleeper feature when it was introduced. With both row compression and page compression, including both prefix and dictionary compression, SQL Server offers the granularity to tune data compression. Using data compression carefully, you can push the envelope for an I/O bound, high-transaction database.
The next chapter continues the thread of technologies used for highly scalable database design with a look at several types of partitioning.
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
