Thank you to our sponsors

 

 

 

All 24 Hours of PASS registrants will automatically become PASS members. (membership is free!)

 


 

 

 

Using Data Compression with SQL Server 2008 and 2008 R2


Return to Session Listings

Presenter: Maciej Pilecki, Project Botticelli
 

Session 10 (21:00 GMT on May 19)
 

Session Details

When used properly, data compression can be a killer feature. It lets you store more data using less disk and memory space, improving cacheability of your data and limiting the number of I/O operations performed. This session looks into the details of data compression and backup compression as available in SQL Server 2008 as well as the Unicode compression available in SQL Server 2008 R2.

 

About the Speaker


Maciej Pilecki is a SQL Server MVP, MCT, and consultant with Project Botticelli. With many years of international experience in SQL Server database development, optimization, and troubleshooting, he spends most of his time traveling around the world advising customers on how to improve performance and reliability of their databases and sharing lessons learned with conference and user group audiences. His favorite topic are SQL Server database engine internals, including SQLOS, storage engine, and query optimizer, but he also ventures into business intelligence, especially data warehousing and data mining.

Maciej likes skiing with his son and trekking in the mountains in his spare time. He has recently climbed Lobuche East – a 21,000 foot mountain in Everest region of the Himalayas.

Register now for 24 Hours of PASS! 



Check out the speaker lineup!


 

 

Copyright 2013 by PASS | Terms Of Use | Privacy Statement | Login