magnify
Home Google Index Size SQL Server 2008 Data Compression
formats

SQL Server 2008 Data Compression

More Detailed about Data Compression can be seen at sqlserver-training.com Follow us at ———————- Website : sqlserver-training.com Twitter : twitter.com Facebook : facebook.com Linked In : in.linkedin.com Subscribe to Emails : feedburner.google.com ================================ Data Compression feature of SQL Server 2008, can reduce the storage footprint of your databases. Often, data compression leads to a degradation in performance; however, SQL Server data compression simply stores data more efficiently in the rows and pages, which means that the in-memory storage when the data is in use is also reduced. In SQL Server 2008, you can compress data for the following objects: A table that is stored as a heap. A table that is stored as a clustered index. A nonclustered index. An indexed view. A partition in a partitioned table or index. SQL Server supports two types of data compression: Row compression and page compression Row Compression Row compression is a more efficient version of data in-row storage. Conceptually, it is based on the SQL Server 2005 vardecimal storage format, which eliminates the leading and trailing zeros in decimal values. Row compression in SQL Server 2008 is a whole new storage structure that reduces the size of the metadata that is required for variable-length columns. It uses no space to store zero and null values, which results in less space being required to store a row. Page Compression Page compression is a superset of (and

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments