Question

我根据时间数据表建立了分职职能,下文是分职停职的文字及其相应的分职计划。

CREATE PARTITION FUNCTION [VZDArchiveDatePartition](datetime) AS RANGE LEFT FOR VALUES
(N 2011-07-01T00:00:00.000 , N 2011-08-01T00:00:00.000 , N 2011-09-01T00:00:00.000 ,
 N 2011-10-01T00:00:00.000 , N 2011-11-01T00:00:00.000 , N 2011-12-01T00:00:00.000 ,
 N 2012-01-01T00:00:00.000 , N 2012-02-01T00:00:00.000 , N 2012-03-01T00:00:00.000 ,
 N 2012-04-01T00:00:00.000 , N 2012-05-01T00:00:00.000 , N 2012-06-01T00:00:00.000 )
GO

CREATE PARTITION SCHEME [VZDArchivePartitionScheme] AS PARTITION [VZDArchiveDatePartition] TO
([PRIMARY], [JulyFG], [AugFG], [SepFG], [OctFG], [NovFG], [DecFG], [Jan12FG],
 [Feb12FG], [Mar12FG], [Apr12FG], [May12FG], [Jun12FG])
GO

In the above Partition FUnction , I have used 1 month as range value.Now I would like to alter the Partition range from Month to Quarter. Please suggest how to alter the existing function which is assigned to multiple tables.

Answer 1

您可分数(见,供解释),但鉴于要合并的分数和多个表格,你可以更好地放弃新的分位办法,并利用新办法重新调整指数。

Answer 2

-- First merge two months into the third one
ALTER PARTITION FUNCTION VZDArchiveDatePartition() MERGE RANGE (N 2011-08-01T00:00:00.000 );
ALTER PARTITION FUNCTION VZDArchiveDatePartition() MERGE RANGE (N 2011-09-01T00:00:00.000 );

-- Then shrink the files and delete them
DBCC SHRINKFILE (N AugFG  , 1) -- Ensure that 0 used, 0 estimated values are returned
DBCC SHRINKFILE (N SepFG  , 1) -- Ensure that 0 used, 0 estimated values are returned

-- At the end, deleting the files and filegroups used might be an idea
ALTER DATABASE [xxx]  REMOVE FILE      [AugFG]
ALTER DATABASE [xxx]  REMOVE FILEGROUP [AugFG]

ALTER DATABASE [xxx]  REMOVE FILE      [SepFG]
ALTER DATABASE [xxx]  REMOVE FILEGROUP [SepFG]

友情链接