SQL Server数据库创建数据仓库已分区表详解

[人工智能] 时间:2025-11-03 20:30:00 来源:益强IT技术网 作者:域名 点击:197次
SQL Server数据库创建数据仓库已分区表详解
复制USE[master]   ALTERDATABASE[AdventureWorksDW]ADDFILEGROUP [fg2001]   GO   ALTERDATABASE[AdventureWorksDW]ADDFILEGROUP [fg2002]   GO   ALTERDATABASE[AdventureWorksDW]ADDFILEGROUP [fg2003]   GOALTERDATABASE[AdventureWorksDW]ADDFILEGROUP [fg2004]   GOALTERDATABASE[AdventureWorksDW]ADDFILE   (NAME =NAdventureWorksDW_Data2001,数数据   FILENAME =NC:Program FilesMicrosoft ServerSecurity/Database/>SQLServerMSServerSecurity/Database/>SQL10.MSServerSecurity/Database/> SQLSERVERMSServerSecurity/Database/>SQLDATAAdventureWorksDW_Data2001.ndf,   SIZE =2048KB , FILEGROWTH =1024KB ) TOFILEGROUP [fg2001]   GO   ALTERDATABASE[AdventureWorksDW]ADDFILE(NAME =NAdventureWorksDW_Data2002,   FILENAME =NC:Program FilesMicrosoft ServerSecurity/Database/>SQLServerMSServerSecurity/Database/> SQL10.MSServerSecurity/Database/>SQLSERVERMSServerSecurity/Database/>SQLDATAAdventureWorksDW_Data2002.ndf,   SIZE =2048KB , FILEGROWTH =1024KB ) TOFILEGROUP [fg2002]   GO   ALTERDATABASE[AdventureWorksDW]ADDFILE(NAME =NAdventureWorksDW_Data2003,   FILENAME =NC:Program FilesMicrosoft ServerSecurity/Database/>SQLServerMSServerSecurity/Database/> SQL10.MSServerSecurity/Database/>SQLSERVERMSServerSecurity/Database/>SQLDATAAdventureWorksDW_Data2003.ndf,   SIZE =2048KB , FILEGROWTH =1024KB) TOFILEGROUP [fg2003]   GO   ALTERDATABASE[AdventureWorksDW]ADDFILE   (NAME =NAdventureWorksDW_Data2004,   FILENAME =NC:Program FilesMicrosoft ServerSecurity/Database/>SQLServerMSServerSecurity/Database/> SQL10.MSServerSecurity/Database/>SQLSERVERMSServerSecurity/Database/>SQLDATAAdventureWorksDW_Data2004.ndf,   SIZE =2048KB , FILEGROWTH =1024KB ) TOFILEGROUP [fg2004]   GO  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.

(责任编辑:IT科技)

    相关内容
    精彩推荐
    热门点击
    友情链接