数据仓库的 RDBMS 性能优化指南
http://www.microsoft.com/china/technet/prodtechnol/sql/2000/maintain/c2061.aspSQL Server 联机丛书 2004 年 1 月更新版
http://www.microsoft.com/china/sql/techinfo/productdoc/2000/books.asp在 Microsoft SQL Server 2000 数据仓库中使用分区
http://www.microsoft.com/china/msdn/archives/library/techart/PartitionsInDW.asp
http://www.microsoft.com/china/technet/prodtechnol/sql/2000/maintain/c2061.aspSQL Server 联机丛书 2004 年 1 月更新版
http://www.microsoft.com/china/sql/techinfo/productdoc/2000/books.asp在 Microsoft SQL Server 2000 数据仓库中使用分区
http://www.microsoft.com/china/msdn/archives/library/techart/PartitionsInDW.asp
/*---建立数据库----*/
Create database samfeng
On primary
( name = samfeng_dat,
filename ='c:\program files\Microsoft sql server\mssql\data\samfeng.mdf',
size = 10,
maxsize = 50,
filegrowth = 10 ),
filegroup SFG1
( name = SFG1_dat1,
filename ='c:\program files\Microsoft sql server\mssql\data\SFG1dat1.ndf',
size = 10,
maxsize = unlimited,
filegrowth = 10 ),
filegroup SFG2
( name = SFG2_dat2,
filename ='c:\program files\Microsoft sql server\mssql\data\SFG2dat2.ndf',
size = 10,
maxsize = unlimited,
filegrowth = 10 )
log on
( name = samfeng_log,
filename ='c:\program files\Microsoft sql server\mssql\data\samfeng.ldf',
size = 5,
maxsize = 25,
filegrowth = 10 )/*---在文件组中建立表----*/
crate table 一月表名
(列1 数据类型,列2 数据类型,……)
on SFG1
go
create table 二月表名
(列1 数据类型,列2 数据类型,……)
on SFG1你如果要整体运用表,可以建立一个联合的视图。
create view 视图名(列1,列2,……)
as
select * from 一月表
union all
select * from 二月表
go如果你要备份那个月份,那么你可以
备份特定的文件或文件组:BACKUP DATABASE { database_name | @database_name_var }
< file_or_filegroup > [ ,...n ]
TO < backup_device > [ ,...n ]
[ WITH
[ BLOCKSIZE = { blocksize | @blocksize_variable } ]
[ [ , ] DESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] DIFFERENTIAL ]
[ [ , ] EXPIREDATE = { date | @date_var }
| RETAINDAYS = { days | @days_var } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] FORMAT | NOFORMAT ]
[ [ , ] { INIT | NOINIT } ]
[ [ , ] MEDIADESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]
[ [ , ] NAME = { backup_set_name | @backup_set_name_var } ]
[ [ , ] { NOSKIP | SKIP } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
就可以了!