Pizza and Networking at 6PM. Presentation to start around 6:30PM.
High-end storage is expensive, and SQL Server data compression can make your database smaller. So lets compress all the tables! No--unfortunately, it's not that easy. We'll talk about how data compression actually works, and the differences between ROW and PAGE compression. As part of this, we'll look at the costs and benefits associated with each type of compression. By the end of this session, you'll have a better idea of when compression is the right solution, as well as what type of compression to use.
Andy is a SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has over 12 years of experience supporting high-volume, highly-available OLTP environments with demanding performance needs. Andy blogs at www.am2.co, and is co-organizer of SQL Saturday Boston.