Compression - row-level and page-level compression - Sql server 2008

Explain Compression - row-level and page-level compression in sql server 2008

Data compression is a feature which is used to reduce disk storage space and increase the performance of the query by reducing the I/O operations.

SQL Server 2008 supports two types of compression – Row-level compression and Page-level compression.

A row-level and page-level compression takes place on the metadata.

Page level compression results in persisting certain common data that affects rows in a single location.

The compression takes place into number of bits. For example, the length of ‘varchar’ will be stored in 3 bits.
What is filtered indexes in sql server 2008? - Sql server 2008
Filtered index in SQL Server 2008 is an index WHERE clause. A filtered index is an optimized non-clustered index.........
Resource governor - Sql server 2008
Resource Governor enables the DBA for managing the work load of SQL Server and critical system resource consumption...........
Plan freezing - Sql server 2008
Plan freezing is a new concept that allows the DBAs to persist plan guides..........
Post your comment