sqlserver
winner2050
专搞c#
展开
-
sqlserver 索引建议
SELECT A.* FROM sys.dm_db_missing_index_details A INNER JOIN sys.databases B ON A.database_id=B.database_id WHERE B.name='数据库名称'原创 2013-09-05 20:54:49 · 681 阅读 · 0 评论 -
查询sqlserver 索引的使用情况
SELECT b.name,* FROM sys.dm_db_index_usage_stats a INNER JOIN sys.indexes b ON a.object_id=b.object_id ORDER BY b.name原创 2013-09-04 21:19:00 · 1152 阅读 · 0 评论 -
SqlServer禁用、启用外键约束
---生成启用or禁用指定表外键约束的sql select '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原创 2013-10-26 16:36:44 · 1066 阅读 · 0 评论