Category: DATA_COMPRESSION

SQL Server Management Studio: scripting does not show Data_Compression by default
By: Date: November 16, 2016 Categories: DATA_COMPRESSION,SQL Server,SSMS

With this post I aim to highlight a feature of  SQL Server Management Studio (SSMS) regarding the DATA_COMPRESSION property when scripting objects. First I create a table and an index with PAGE compression: use TESTDB GO CREATE TABLE People ( PersonID int, LastName varchar(200), FirstName varchar(200), Address varchar(200), Phone varchar(20) ); CREATE NONCLUSTERED INDEX [comp_index_LastName] ON [dbo].[People]…

Read More →