Storing fixed-length numeric data types and CHAR data types as though they were variable-length data types.Row-level compression uses the following strategies to save space: Row-level compression works by using more efficient storage formats for fixed-length data. To learn more about heaps, see Heaps (Tables without Clustered Indexes) in the MSDN library. There are three forms of data compression you can use with SQL Server: row-level compression, unicode compression, and page-level compression. Individual partitions of a partitioned table or index.Heap tables (a heap is a table without a clustered index).You can configure data compression on the following: You cannot use data compression with system tables, and only the Enterprise and Developer editions of SQL Server support data compression.
Data compression has the drawback of increasing CPU usage because the data must be compressed and decompressed when being accessed. Row and page compression for tables and indexes enables you to save storage space by reducing the size of the database.
0 kommentar(er)
