The Ins and Outs of SQL Server Data Compression - Bob Pusateri

While data compression is best-known for reducing a database's size on disk, it's also an effective tool for making your queries fly. Come see how reduced disk usage and increased performance mean that with compression, less really can be more! This session will arm you with the knowledge and understanding to capitalize on both of these aspects of SQL Server's row and page compression features, as well as columnstore and updateable columnstore indexes. We'll combine a lesson on the internals of compression with real-world scenarios to show you how to determine the most appropriate compression type for any situation. Since there's no such thing as a "free lunch" in computing, the drawbacks of these features will also be discussed.