title: Compression for very large tables
body: <p>I have three very big tables in our production system, I need to do a compression for those tables. I tried to do it by each partitions to save the time because every time I run the compression query will cause the table offline. But it still cost about a day to compress a single partition. Does anyone know a way can help me to compress the tables without cost a long outage time for the system.</p>
  
  <p></p>
  
  <pre><code>ALTER TABLE &lt;table_name&gt; 
  REBUILD PARTITION = ALL 
  WITH (DATA_COMPRESSION = PAGE ON PARTITIONS(&lt;range&gt;),
  ... 
  </code></pre>
  
  <p>)</p>