Level: Introductory to Intermediate
This session will discuss the basics of how compression and de-duplication reduce your data volume.
Much like the cars of the 1970s sacrificed gas mileage for better performance, database technology has also made its share of sacrifices for efficiency. Fortunately, times have changed significantly since then. Just as adding a turbocharger to a car delivers more power while saving fuel, the addition of compression to a database accelerates read performance while saving disk space.
Come learn how, why, and when compression is the solution to your database performance problems. This session will discuss the basics of how compression and de-duplication reduce your data volume. We'll review the three different types of compression in SQL Server 2012, including the overhead and benefits of each and the situations for which each is appropriate, and examine the special type of compression used for ColumnStore indexes to help your data warehouse queries fly. As with turbo, data compression also has drawbacks, which we'll cover as well.
You will learn:
- The costs and benefits of using data compression in SQL Server
- Best practices for when and how to use compression in your database
- An understanding of how columnstore indexes can be used in SQL Server