dbcc sqlperf('umsstats') Statistic Value -------------------------------- ------------- Node Id 0 Avg Sched Load 9 Sched Switches 1001897 Sched Pass 4.566968E+07 IO Comp Passes 4.267942E+07 Scheduler ID 0 online 1 num tasks 9 num runnable …

ALTER DATABASE FORT MODIFY FILE(NAME = TRANSACTIONNAME, MAXSIZE = Unlimited)

EXEC sp_helpdb 'DBNAME'

SQL Server 2005で使用可 DECLARE @StartTime datetime SET @StartTime = GETDATE()/* ここに処理時間を計測したいSQL文を書く */SELECT CONVERT(varchar,GETDATE()-@StartTime,114) AS 実行時間 SQL Server 2008で使用可 値はナノ秒 DECLARE @STARTTIME dat…

PLAN A select so.name as テーブル名, sc.name as 列名, st.name as データ型, sc.length as 長さ, sc.isnullable as NULL許可 from sysobjects so join syscolumns sc on so.id=sc.id join systypes st on sc.xtype=st.xtype where so.type='U' /* すべて…

CREATE TABLE #SPACES ([name][sysname],[rows][bigint],[reserved][varchar](18), [data][varchar](18),[index_size][varchar](18),[unused][varchar](18)) DECLARE @table sysnameDECLARE C CURSOR LOCAL FOR SELECT name FROM sysobjects WHERE XTYPE='U'…

SQL Server 2000 SELECT * FROM sysobjects WHERE xtype = 'u' SQL Server 2005以降 SELECT * FROM Sys.Tables