SHARE
TWEET

Compression Repro

SQLSoldier Jul 2nd, 2016 93 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Create Database TestCompression;
  2. Go
  3.  
  4. Use TestCompression;
  5.  
  6. Create Table dbo.TestComp (ValID int identity(1, 1) not null primary key,
  7.                         TestVal char(4000) not null default('a'))
  8.         With (Data_Compression = Page);
  9. Go
  10.  
  11. Insert Into dbo.TestComp Default Values;
  12. Go 10000
  13.  
  14. Select rows, data_compression_desc
  15. From sys.partitions
  16. Where object_id = OBJECT_ID(N'dbo.TestComp');
RAW Paste Data
Top