winner2050的专栏

SELECT A.* FROM sys.dm_db_missing_index_details A INNER JOINsys.databases B ON A.database_id=B.database_idWHERE B.name='数据库名称'

SELECT b.name,* FROM sys.dm_db_index_usage_stats aINNER JOIN sys.indexes b ON a.object_id=b.object_idORDER BY b.name

---生成启用or禁用指定表外键约束的sqlselect 'ALTER TABLE ' + b.name + ' NOCHECK CONSTRAINT ' +a.name +';'  from sysobjects a ,sysobjects b wherea.xtype ='f' and a.parent_obj = b.id ;select 'ALTER TABLE ' + b.nam