- In Microsoft SQL Server 2008, you have a table without a clustered index.
- You enable PAGE compression on the table.
- You shrink the database.
Note ROW compression will not be affected by this problem. This includes scenarios in which ROW compression is being used directly and scenarios in which ROW compression is used as part of PAGE compression.
Service pack informationTo resolve this problem, obtain the latest service pack for SQL Server 2008. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
Cumulative update informationThe fix for this issue was first released in Cumulative Update 4. For more information about how to obtain this cumulative update package for SQL Server 2008, click the following article number to view the article in the Microsoft Knowledge Base:
- Create clustered index on the table.
- Shrink the database.
- Drop the clustered index.
SELECT page_count FROM sys.dm_db_index_physical_stats (
NULL, NULL, 'SAMPLED');
Article ID: 963658 - Last Review: Apr 7, 2009 - Revision: 1