Using Compression to Improve Database Performance

Speaker(s)Joseph D'Antoni

Duration: 60 minutes

Track: Room A

Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression.

Accompanying Materials:

No material found.

Back to Top