SQL Server Compression and what it can do for You

Categories: Presentations
Tags: No Tags
Comments: No Comments
Published on: May 30, 2015

ABSTRACT

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.

Material Download

No Comments - Leave a comment

Leave a comment

Your email address will not be published. Required fields are marked *










Calendar
May 2015
M T W T F S S
« Apr   Jun »
 123
45678910
11121314151617
18192021222324
25262728293031
Content
SQLHelp

SQLHelp


Welcome , today is Monday, July 24, 2017