Reference: http://www.cnblogs.com/knowledgesea/p/3696912.html
and Baidu Search SQL Server table partition
create partition function Sgy_partitionfun (int) as range left for values (n ' 10000 ', n ' 20000 ')//drop partition function Sgy _partitionfunbegin transaction--Creating a partition scheme create PARTITION scheme [Bgpartitionschema] as PARTITION sgy_partitionfun to ([ PRIMARY], Filegroup1, filegroup2)--Creating a partitioned index create CLUSTERED index [Clusteredindex_on_bgpartitionschema_ 635342971076448165] on Gms_item ( Gameserverid) with (sort_in_tempdb = off, Ignore_dup_key = off, drop_existing = off, O NLINE = OFF) on [Bgpartitionschema] (Gameserverid)--delete partition index [Clusteredindex_on_bgpartitionschema_ 635342971076448165] on Gms_item with (ONLINE = OFF) COMMIT Transactionselect * from Gms_item where $partition. Sgy_partiti Onfun (Gameserverid) =1
SQL Server Table Partitioning