O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing compressed storage features for tables and indexes

Whenever data is inserted into a table or an index is rebuilt, the database engine requires more space in the database, which is usually the underlying storage where the data file is located. The database engine needs the process to determine where space is available within the pages to be allocated. Therefore, the insert process must find a mixed extent with one or more pages available that can be allocated, if the index or data is more than eight pages or larger than what a free uniform extent needs to be allocated.

SQL Server 2008 has introduced the data compression feature as a part of the programmability enhancements. The main benefit of compression is that it can be enabled or ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required