创建文件组
alter database dbname add filegroup fq_01
alter database dbname add file(name = 'fq_01',filename = 'f:\database\fq_01.mdf',size = 1mb,filegrowth = 1mb)to filegroup fq_01
...
创建分区函数
create partition function pf_table(int) as range right for values (20130101,20160101,20190101)--right:<;left:<=
创建分区方案
create partition scheme ps_table as partition pf_table to (fq_01,...)
关联分区方案
create index ix_fq on tablename(date) on ps_table(date)
drop index ix_fq on tablename
统计分区行数
select $partition.[pf_table](date) p,count(1) from tablename group by $partition.[pf_table](date) order by p
合并分区
alter partition function pf_table()merge range(20130101)
添加分区
alter partition scheme ps_table next used filegroupname
alter partition function pf_table()split range(20130101)
删除分区
drop partition scheme ps_table
drop partition function pf_table
alter database dbname remove file fq_01
alter database dbname remove filegroup fq_01
...