O'Reilly logo
  • Dustin Waybright thinks this is interesting:

The following command adds row-level compression to the Production.OrderDetails table as part of the CREATE TABLE statement.

CREATE TABLE Sales.OrderDetails
(
  orderid   INT           NOT NULL,
...
  )
    WITH (DATA_COMPRESSION = ROW);

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

Compression is done in a WITH clause following a TABLE statement.