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)