数据压缩（in Sql2008）

Use NorthwindCS
Go
Create table T1
(Id int Identity,
 Name char(1000))
 Go
Declare @n int
Set @n=0
While @n<50000
Begin
 Insert T1 Values ('Frank')
 Set @n=@n+1
End
Go
Exec sp_spaceused T1
--57224 KB
--  592 KB
Alter table T1
Rebuild
With (Data_Compression = Page)

Create table T2
(Id int Identity,
 Name char(1000))
With (Data_Compression = Page)