Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server Property Editors › SQL Server Common Functionality › Define Data Compression for Tables, Table Indexes, or View Indexes in SQL Server

Define Data Compression for Tables, Table Indexes, or View Indexes in SQL Server

The DataCompression tab is in the SQL Server Table Editor, SQL Server Table Index Editor, and the SQL Server View Index Editor in a SQL Server 2008, 2012, 2014, and 2016 physical model. You use the DataCompression tab in these editors to define how table data is compressed to reduce the amount of storage space it needs.

To define data compression for a table, table index, or view index

1. Open the physical property editor for the object (table, table index, or view index) for which you want to define data compression.
2. Select the object in the Navigation Grid for which you want to define data compression.

   Note: Use the Enter filter text box to filter a very large list of objects to quickly locate the one for which you want to define data compression.

3. Click the DataCompression tab.
4. Select the data compression object in the grid that you want to define and work with the following options:

   Note: Click New on the toolbar create a new data compression object if there are none displayed in the grid.

   Type

   Specifies the type of compression. Select a value from the drop-down.

   Partition Element

   Specifies the partition to which the data compression applies. Select the partition element from the drop-down.

   Note: The name of the data compression object is generated from its partition element.

5. Click Close.

   Data compression is defined and the property editor closes.