title: How do I set compression to "none" for all of the tables in a SQL Server database
body: <p>I need to set the <code>DataCompressionOptions</code> to <code>None</code> for all of the tables in a database. </p>
  
  <p>I can run</p>
  
  <pre><code>USE [MyDatabase]
  
  ALTER TABLE [dbo].[Tablex] 
  REBUILD PARTITION = ALL
  WITH (DATA_COMPRESSION = NONE)
  </code></pre>
  
  <p>And it works fine but I need to set this for about 50 tables.</p>