SQL Server 3

First, data compression

1. Row compression

Row compression stores fixed-length types as variable-length storage types. For example, using a char (100) data column to store the string "SQL Server 2012" requires only 15 characters to be stored after compression. (this compression mode optimizes null and 0 values for all data types)

2. Page compression

Page compression builds on row compression, minimizing stored redundant data by storing only the same bytes on the page at a time.

(1) Right click on the table name, select "Save" and then "manage Compression", namely:

(2) Go to the Data Compression Wizard page, select the compression type (row refers to row compression, page refers to the compression of pages), that is:

SQL Server 3