sqlserver创建分区表

–创建文件组

   ALTER DATABASE InsideTSQL2008 ADD FILEGROUP [InsideTSQL2008_FileGroup_1]
ALTER DATABASE InsideTSQL2008 ADD FILEGROUP [InsideTSQL2008_FileGroup_2]
ALTER DATABASE InsideTSQL2008 ADD FILEGROUP [InsideTSQL2008_FileGroup_3]
ALTER DATABASE InsideTSQL2008 ADD FILEGROUP [InsideTSQL2008_FileGroup_4]
GO

–给文件组添加文件
一个文件组一个文件，便于管理。
根据表实际情况预估文件属性，这里设置初始大小为5M，增量为10%，也可以指定为具体数字。最大值不设限制。

 alter database InsideTSQL2008 add file
 (name=InsideTSQL2008_File_1,filename='C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\InsideTSQL2008_File_1.ndf',SIZE=5MB,
 maxsize=UNLIMITED,filegrowth=10%) to filegroup [InsideTSQL2008_FileGroup_1];
 alter database InsideTSQL2008 add file
 (name=InsideTSQL2008_File_2,filename='C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\InsideTSQL2008_File_2.ndf',SIZE=5MB,
 maxsize=UNLIMITED,filegrowth=10%) to filegroup [InsideTSQL2008_FileGroup_2];
  alter database InsideTSQL2008 add file
 (name=InsideTSQL2008_File_3,filename='C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\InsideTSQL2008_File_3.ndf',SIZE=5MB,
 maxsize=UNLIMITED,filegrowth=10%) to filegroup [InsideTSQL2008_FileGroup_3];
  alter database InsideTSQL2008 add file
 (name=InsideTSQL2008_File_4,filename='C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\InsideTSQL2008_File_4.ndf',SIZE=5MB,
 maxsize=UNLIMITED,filegrowth=10%) to filegroup [InsideTSQL2008_FileGroup_4];

–查看数据库中文件情况

select name,type_desc,ph