搜索

千万级SQL Server数据库表分区的实现

发表于 2025-11-05 07:53:39 来源:益强智未来
千万级SQL Server数据库表分区的实现
复制IF  EXISTS (SELECTnameFROM sys.databases WHEREname = NAirAvCache)   DROPDATABASE [AirAvCache]   GO   CREATEDATABASE [AirAvCache]   ONPRIMARY (NAME=Data Partition DB Primary FG,千万   FILENAME=   D:\Data\Primary\AirAvCache Primary FG.mdf,   SIZE=5,   MAXSIZE=500,   FILEGROWTH=1 ),   FILEGROUP [AirAvCache FG1]   (NAME = AirAvCache FG1,   FILENAME =   D:\Data\FG1\AirAvCache FG1.ndf,   SIZE = 5MB,   MAXSIZE=500,   FILEGROWTH=1 ),   FILEGROUP [AirAvCache FG2]   (NAME = AirAvCache FG2,   FILENAME =   D:\Data\FG2\AirAvCache FG2.ndf,   SIZE = 5MB,   MAXSIZE=500,   FILEGROWTH=1 ),   FILEGROUP [AirAvCache FG3]   (NAME = AirAvCache FG3,   FILENAME =   D:\Data\FG3\AirAvCache FG3.ndf,   SIZE = 5MB,   MAXSIZE=500,   FILEGROWTH=1 ),   FILEGROUP [AirAvCache FG4]   (NAME = AirAvCache FG4,   FILENAME =   D:\Data\FG4\AirAvCache FG4.ndf,   SIZE = 5MB,   MAXSIZE=500,   FILEGROWTH=1 ),   FILEGROUP [AirAvCache FG5]   (NAME = AirAvCache FG5,   FILENAME =   D:\Data\FG5\AirAvCache FG5.ndf,   SIZE = 5MB,   MAXSIZE=500,   FILEGROWTH=1 ),   FILEGROUP [AirAvCache FG6]   (NAME = AirAvCache FG6,   FILENAME =   D:\Data\FG6\AirAvCache FG6.ndf,   SIZE = 5MB,   MAXSIZE=500,   FILEGROWTH=1 ),   FILEGROUP [AirAvCache FG7]   (NAME = AirAvCache FG7,   FILENAME =   D:\Data\FG7\AirAvCache FG7.ndf,   SIZE = 5MB,   MAXSIZE=500,   FILEGROWTH=1 ),   FILEGROUP [AirAvCache FG8]   (NAME = AirAvCache FG8,   FILENAME =   D:\Data\FG8\AirAvCache FG8.ndf,   SIZE = 5MB,   MAXSIZE=500,   FILEGROWTH=1 ),   FILEGROUP [AirAvCache FG9]   (NAME = AirAvCache FG9,   FILENAME =   D:\Data\FG9\AirAvCache FG9.ndf,   SIZE = 5MB,   MAXSIZE=500,   FILEGROWTH=1 ),   FILEGROUP [AirAvCache FG10]   (NAME = AirAvCache FG10,   FILENAME =   D:\Data\FG10\AirAvCache FG10.ndf,   SIZE = 5MB,   MAXSIZE=500,   FILEGROWTH=1 ),   FILEGROUP [AirAvCache FG11]   (NAME = AirAvCache FG11,   FILENAME =   D:\Data\FG11\AirAvCache FG11.ndf,   SIZE = 5MB,   MAXSIZE=500,   FILEGROWTH=1 ),   FILEGROUP [AirAvCache FG12]   (NAME = AirAvCache FG12,   FILENAME =   D:\Data\FG12\AirAvCache FG12.ndf,   SIZE = 5MB,   MAXSIZE=500,   FILEGROWTH=1 )  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.80.81.82.83.84.85.86.87.88.89.90.91.92.93.94.95.96.97.98.99.100.101.102.103.
随机为您推荐
版权声明:本站资源均来自互联网,如果侵犯了您的权益请与我们联系,我们将在24小时内删除。

Copyright © 2016 Powered by 千万级SQL Server数据库表分区的实现,益强智未来  滇ICP备2023006006号-17sitemap

回顶部