Chapter 7. Table compression
After completing this chapter, you will be able to
Understand the different types of compression.
Understand how to compress a table or index.
Determine when to compress a table or index.
We often hear that disk space is cheap and that we should not be too concerned if databases are growing at an excessive rate. Just buy more disks. Well, what most managers do not realize is that we are not talking about disks that you buy at some large electronic store. Microsoft SQL Server and other RDBMSs require fast redundant sets of disks. That coupling takes disk price from cheap to often very expensive. In addition, if you must include high availability and disaster recovery as part of your topology, then your costs are doubled. ...
Get Microsoft® SQL Server® 2012 Step by Step 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.
