MS SQL Server 備忘録

SQL Server Management Studio

SQL実行

"New Query" / File->New->Query with...

SQL Server Management StudioでSQLを実行する方法 | SQLServer初心者でもスッキリわかる

ミリ秒計測(SSMSで)

set statistics time on

<query>

set statistics time off

で、"Message"タブを見る

インデックス確認

 SELECT
     convert(varchar, i.name) AS index_name
     , convert(varchar, o.name) AS table_name
     , convert(varchar, col.name) AS column_name
 FROM
     sysindexkeys ik
     ,sysobjects o
     ,syscolumns col
     ,sysindexes i
 WHERE
         ik.id = o.id
     AND ik.id = col.id
     AND ik.colid = col.colid
     AND ik.id = i.id
     AND ik.indid = i.indid
     AND o.xtype = 'U'
     AND o.name in ('NodeInstanceLog', 'AuditTaskImpl')
 ORDER BY
     i.name
     ,ik.id
     ,ik.indid
     ,ik.keyno