use playpen
go
create table comptests (
	A bigint not null identity(144115188075855872,-3) primary key clustered,
	B varchar(108) not null default (''),
	C varchar(108) not null default (''),
	D varchar(108) not null default (''),
	E varchar(108) not null default (''),
	F varchar(108) not null default (''),
	G varchar(216) not null default(''),
	H varchar(216) not null default(''),
	I int not null default(0), 
	J int not null default(0), 
	K int not null default(0), 
	L bigint not null default(0))
select top 4000 identity(bigint, 284135188075895873,-113) as X 
	into #t
	from master.sys.all_columns T1, master.sys.all_columns T2
select top 4000 IDENTITY(int,410002,37) as Y 
	into #u
	from master.sys.all_columns T1, master.sys.all_columns T2
select top 4000 IDENTITY(int, 2000000000, -97) as Z 
	into #v
	from master.sys.all_columns T1, master.sys.all_columns T2
create table #w1 (Y int, II int identity(1,1) primary key)
insert #w1(Y) select Y from #u order by Y desc
create table #w2 (Z int, IJ int identity(1,1) primary key)
insert #w2(Z) select Z from #v order by Z asc
create table #w3 (X bigint not null, IH int identity(1,1) primary key)
insert #w3(X) select X from #t order by X desc
declare @x varchar(108) = cast(newid()as char(36))+cast(newid()as char(36))+
	cast(newid()as char(36))
declare @y varchar(108) = cast(newid()as char(36))+cast(newid()as char(36))+
	cast(newid()as char(36))
	drop table #t, #u, #v
;with WW as (select X, Y, Z 
	from #w1, #w2, #w3 
	where II=IH and IJ=IH)
	insert comptests(L,K,J,I,H,G,F,E) select X,Y,Z,Z%Y,
		case(X%2) when 0 then @y else @x end, 
		case(X%2) when 1 then @x else @y end, 
		case(X%2) when 0 then @x else @y end, 
		case(X%2) when 1 then @y else @x end 
		from WW order by X desc
drop table #w1,#w2,#w3
update comptests set 
	B = SUBSTRING(E,1,54)+SUBSTRING(F,1,54),
	C = SUBSTRING(E,1,54)+SUBSTRING(G,1,54),
	D = SUBSTRING(E,1,54)+SUBSTRING(H,1,54)
select top 10 * from comptests
checkpoint
checkpoint
backup database playpen to DISK='c:\playpen\PP_NONE_NO.bak'
	with no_compression, init
checkpoint
backup database playpen to DISK='c:\playpen\PP_NONE_YES.bak'
	with compression, init
alter table comptests REBUILD WITH (DATA_COMPRESSION = PAGE)
alter table Tally REBUILD WITH (DATA_COMPRESSION = PAGE)
checkpoint
checkpoint
backup database playpen to DISK='c:\playpen\PP_PAGE_NO.bak'
	with no_compression, init
checkpoint
backup database playpen to DISK='c:\playpen\PP_PAGE_YES.bak'
	with compression, init
checkpoint
go
use msdb
go
SELECT TOP 4 [backup_set_id]
      ,[backup_size]
      ,[compressed_backup_size]
      ,[media_set_id]
      ,[first_lsn]
      ,[last_lsn]
      ,[checkpoint_lsn]
      ,[database_backup_lsn]
      ,[backup_finish_date]
      ,[recovery_model]
      FROM [msdb].[dbo].[backupset]
      order by [backup_set_id] desc
  go
use playpen
go
drop table comptests
alter table tally REBUILD WITH (DATA_COMPRESSION = NONE)
checkpoint
go