MSSQL

常用SQL语句

添加FILEGROUP及FILE
ALTER DATABASE ascdb_v2_f
ADD FILEGROUP FG_INDEX

ALTER DATABASE ascdb_v2_f
ADD FILE (NAME=INDEX_FILE, FILENAME=’D:\MSSQL\ascdb_v2_f_index.ndf’) TO FILEGROUP FG_INDEX

查看每个表占用的磁盘空间

select object_name(id) tablename, 8*reserved/1024 reserved, 
    rtrim(8*dpages/1024)+ 'Mb' used, 8*(reserved-dpages)/1024 unused, 
    8*dpages/1024-rows/1024*minlen/1024 free, rows 
from sysindexes 
where indid=1 order by reserved desc

创建数据库并指定排序集

CREATE DATABASE mydb ON
PRIMARY (
NAME = ascdb_v2_f_data,
FILENAME = ‘E:\MSSQL\User_Data\mydb_data.mdf’,
SIZE = 10MB,
FILEGROWTH = 10%)

LOG ON (
NAME = ascdb_v2_f_log,
FILENAME = ‘E:\MSSQL\User_Data\mydb.ldf’,
SIZE = 10MB,
FILEGROWTH = 10%)

COLLATE SQL_Latin1_General_CP1_CI_AS
GO