ALTER TABLE REBUILD WITH(DATA COMPRESSION=PAGE,MAXDOP=8)
Implementing table compression use server MAXDOP (sp_configure 'max degree of parallelism') if you dont set MAXDOP in statement.
A good explanation of page compression and the MAXDOP setting is here >
http://sqlblog.com/blogs/linchi_shea/archive/2008/05/05/sql-server-2008-page-compression-using-multiple-processors.aspx
No comments:
Post a Comment