Data compression
In SQL Server, large-value data types, because of their size, are sometimes stored separately from the normal row data on special purpose pages. Is data compression available for the data that is stored separately?
- Yes
- No
| No |
Explanation: | The data stored off the row is not compressed.
Ref: Data Compression - http://msdn.microsoft.com/en-us/library/cc280449.aspx
|
Some more info about data compression:
In addition to saving space, data compression can help improve performance of I/O intensive workloads because the data is stored in fewer pages and queries need to read fewer pages from disk. However, extra CPU resources are required on the database server to compress and decompress the data, while data is exchanged with the application. Data compression can be configured for the following database objects
0 comments:
Post a Comment