Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Until SQL Server 7.0 was released, the page size in SQL Server was 2K; now the page size is 8K.
Microsoft introduced page compression in SQL Server 2008. This new feature is available in the Enterprise edition and developer edition. The page compression feature of SQL Server can compress the entire page.
Page compression is applied only when the page gets full. When page compression occurs there are three operations that happen in the following order:
- Row compression
- Prefix compression
- Dictionary compression
