Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Create Database TestCompression;
- Go
- Use TestCompression;
- Create Table dbo.TestComp (ValID int identity(1, 1) not null primary key,
- TestVal char(4000) not null default('a'))
- With (Data_Compression = Page);
- Go
- Insert Into dbo.TestComp Default Values;
- Go 10000
- Select rows, data_compression_desc
- From sys.partitions
- Where object_id = OBJECT_ID(N'dbo.TestComp');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement