sqlserver分区问题

概述sqlserver修改user_message分区表 分区组和分区文件 ALTER DATABASE [BI_Baihe] ADD FILEGROUP [User_MessageFG2015M01] ALTER DATABASE [BI_Baihe] ADD FILEGROUP [User_MessageFG2015M02] ALTER DATABASE [BI_Baihe] ADD FILE (

sqlserver修改user_message分区表
分区组和分区文件
ALTER DATABASE [BI_Baihe] ADD fileGROUP [User_MessageFG2015M01]
ALTER DATABASE [BI_Baihe] ADD fileGROUP [User_MessageFG2015M02]
ALTER DATABASE [BI_Baihe] ADD file ( name = N'User_Message2015M01',filename = N'E:\BIDataBases\User_Message\User_MessageFG2015M01.ndf',SIZE = 5683392KB,MAXSIZE = UNliMITED,fileGROWTH = 10% )
TO fileGROUP [User_MessageFG2015M01]
ALTER DATABASE [BI_Baihe] ADD file ( name = N'User_Message2015M02',filename = N'E:\BIDataBases\User_Message\User_MessageFG2015M02.ndf',fileGROWTH = 10% )
TO fileGROUP [User_MessageFG2015M02]
处理分区方案和分区函数
use BI_baihe
go
alter partition scheme SendDatePS  next used [User_MessageFG2015M01]
alter partition function SendDatePF() split range(N'2015-01-01T00:00:00.000')
go

alter partition scheme SendDatePS  next used [User_MessageFG2015M02] alter partition function SendDatePF() split range(N'2015-02-01T00:00:00.000')

总结

以上是内存溢出为你收集整理的sqlserver分区问题全部内容，希望文章能够帮你解决sqlserver分区问题所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。