Accelerate Database Performance Through Data Compression
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 deduplication 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.
Sorry, there are no downloads available for this session.
Joey D'Antoni is a Solutions Architect at Anexinet for SQL Server and Big Data platforms with a background as production DBA and Infrastructure Architect for Fortune 500 firms. His specialties include infrastructure architecture and design, disaster recovery and hybrid cloud scenarios.
Joey is a speaker on many IT topics such as Cloud Computing, Big Data and a number of topics on SQL Server. He holds a MBA from North Carolina State University, and is MSCE for Business Intelligence.
The video is not available to view online.