You can use the following syntax.
ALTER TABLE Table_Name
REBUILD PARTITION = ALL
WITH( DATA_COMPRESSION = NONE)
Replace "Table_Name" with actual table name before executing the script.
To learn more about Table compression use the following MSDN link Table Compression
No comments:
Post a Comment