footleg

导航

2017年7月4日

sqlserver2008 查看数据库自带的索引建议

摘要： select object_name(object_id), i.name from sys.indexes i where i.index_id NOT IN (select s.index_id from sys.dm_db_index_usage_stats s where s.object_ 阅读全文

posted @ 2017-07-04 18:10 迷途 阅读(342) 评论(0) 推荐(0) 编辑

sqlserver使用sql导出索引

摘要： BEGIN WITH tx AS ( SELECT a.object_id , b.name AS schema_name , a.name AS table_name , c.name AS ix_name , c.is_unique AS ix_unique , c.type_desc AS i 阅读全文

posted @ 2017-07-04 18:05 迷途 阅读(1222) 评论(0) 推荐(0) 编辑