sql server 2005中的表分区

 
set @count =201
while @count <=300
begin
insert into MyTable select @count,getdate(),300.00
set @count=@count 1
end
set @count =301
while @count <=400
begin
insert into MyTable select @count,getdate(),400.00
set @count=@count 1
end
set @count =401
while @count <=800
begin
insert into MyTable select @count,getdate(),500.00
set @count=@count 1
end

最后，我们可以查询下，插入的这些数据，是否真的被划分到四个不同的文件组里的表分区了，可以这样看
SELECT *, $PARTITION.[Data Partition Range](ID)
FROM MyTable

http://www.cnblogs.com/jackyrong/archive/2006/11/13/559354.html

共2页: 上一页 [1] 2 下一页

评论加载中…