CODEWITHSUNDEEP
sqlsql-server-2012
Mukund Thakkar
Mukund Thakkar

Reputation: 1295

How do i compress database table in sql server 2012 Standard Edition

How do i compress database table in sql server 2012 Standard Edition.

The below query is working with my development machine having enterprise edition but live server having standard edition. And My database is too large and requires compression.

ALTER TABLE [dbo].Table1 REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE )

Upvotes: 1

Views: 7624

Answers (1)

steoleary
steoleary

Reputation: 9278

Data compression is an enterprise feature only, please see the following link for details of features available in each edition:

http://technet.microsoft.com/en-us/library/cc645993.aspx

Upvotes: 5

Related Questions