#眉標=SQL Server 2008、Parallel、VarDecimal
#副標=實作資料庫系統調校（4）
#大標=SQL Server 2008資料壓縮應用實作
#作者=文／圖	 陳泓翔


===<反灰>=============
dbcc updateusage（'demotest', 'mytbl'）  
exec sp_spaceused mytbl
==<end>==============



===<反灰>=============
EXEC sp_estimate_data_compression_savings 'dbo', 'mytbl', NULL, NULL, 'Page' ;
==<end>==============



===<反灰>=============
delete top（1000） from dbo.mytbl where id between 3000 and 13000
==<end>==============



===<反灰>=============
ALTER TABLE dbo.mytbl
REBUILD WITH （DATA_COMPRESSION=PAGE, MAXDOP=2）;
==<end>==============




===<反灰>=============
ALTER TABLE dbo.mytbl   
REBUILD WITH (DATA_COMPRESSION=NONE, MAXDOP=2);
==<end>==============




======<反灰>=============
truncate table dbo.mytbl
declare @i int
set @i = 1
while @i <= 1000000
begin
insert into dbo.mytbl values('ricoisme')
set @i = @i + 1
end
go
=====<end>==============




===<反灰>=============
ALTER TABLE dbo.mytbl 
REBUILD WITH (DATA_COMPRESSION=ROW, MAXDOP=2);
==<end>==============



===<反灰>=============
ALTER TABLE dbo.mytbl 
REBUILD WITH (DATA_COMPRESSION=ROW, MAXDOP=2);
==<end>==============