SQLSaturday #227 Charleston–Jason Brimhall

Jason Brimhall, a Microsoft Certified Master and Principal Consultant at SQL Solutions Group, presented at the Charleston SQLSaturday event on Oct. 12, 2013.

His topic was “SQL 2012 Table Compression

SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.

 
 
Loading Map....

Date/Time
Date(s) - 10/12/2013
8:00 AM - 5:30 PM

Location
Charleston Southern University

Categories