SqlServer2005對(duì)現(xiàn)有數(shù)據(jù)進(jìn)行分區(qū)具體步驟

RegMail是用來(lái)存放注冊(cè)郵件的表,現(xiàn)以創(chuàng)建時(shí)間(CreateTime)字段來(lái)給表進(jìn)行分區(qū),具體步驟如下:--為分區(qū)創(chuàng)建存儲(chǔ)文件ALTER DATABASE Test ADD FILEGROUP RegMailFile2007ALTER DATABASE Test ADD FI