sql-分区

 1 alter database rfdb add filegroup rf_test1
 2 alter database rfdb add filegroup rf_test2
 3 alter database rfdb add filegroup rf_test3
 4 
 5 alter database rfdb add file(name=‘rf_test1‘,filename=‘D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\rf_test1.ndf‘,size=5MB,maxsize=100MB,filegrowth=5Mb) to filegroup rf_test1
 6 alter database rfdb add file(name=‘rf_test2‘,filename=‘D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\rf_test2.ndf‘,size=5MB,maxsize=100MB,filegrowth=5Mb) to filegroup rf_test2
 7 alter database rfdb add file(name=‘rf_test3‘,filename=‘D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\rf_test3.ndf‘,size=5MB,maxsize=100MB,filegrowth=5Mb) to filegroup rf_test3
 8 go
 9 
10 create partition function partfunrft(datetime) as range left for values (‘2010-01-01‘,‘2011-01-01‘)
11 create partition scheme partsherft as partition partfunrft to (rf_test1,rf_test2,rf_test3)