博客园-Tianjon-最新评论http://www.cnblogs.com/Tianjon/CommentsRSS.aspxzh-cnMon, 18 May 2009 14:47:47 GMTMon, 18 May 2009 14:47:47 GMTcnblogsre: 统计数据库空间的使用情况http://www.cnblogs.com/Tianjon/archive/2009/01/16/1377214.html#1433271Keep WalkingKeep WalkingFri, 16 Jan 2009 11:41:22 GMThttp://www.cnblogs.com/Tianjon/archive/2009/01/16/1377214.html#1433271on (a.object_id = b.id) order by a.user_seeks desc

这个还附带了name，供楼主参考吧，删除那些既不扫描也不查找的索引即是

Keep Walking 2009-01-16 19:41 发表评论
]]>re: 统计数据库空间的使用情况http://www.cnblogs.com/Tianjon/archive/2009/01/16/1377214.html#1433267Keep WalkingKeep WalkingFri, 16 Jan 2009 11:38:12 GMThttp://www.cnblogs.com/Tianjon/archive/2009/01/16/1377214.html#1433267 SELECT database_id, object_id, index_id,
user_seeks, user_scans, user_lookups, user_updates,
last_user_seek, last_user_scan, last_user_lookup, last_user_update,
system_seeks, system_scans, system_lookups, system_updates,
last_system_seek, last_system_scan, last_system_lookup, last_system_update
FROM OpenRowSet(TABLE LOGINDEXSTATS)
WHERE status = 0


这个是sys.dm_db_index_usage_stats的定义

Keep Walking 2009-01-16 19:38 发表评论
]]>re: 统计数据库空间的使用情况http://www.cnblogs.com/Tianjon/archive/2009/01/16/1377214.html#1433266Keep WalkingKeep WalkingFri, 16 Jan 2009 11:36:30 GMThttp://www.cnblogs.com/Tianjon/archive/2009/01/16/1377214.html#1433266sys.dm_db_index_usage_stats
....
....
好多呢


Keep Walking 2009-01-16 19:36 发表评论
]]>re: 统计数据库空间的使用情况http://www.cnblogs.com/Tianjon/archive/2009/01/16/1377214.html#1433230梁逸晨梁逸晨Fri, 16 Jan 2009 10:12:47 GMThttp://www.cnblogs.com/Tianjon/archive/2009/01/16/1377214.html#1433230
梁逸晨 2009-01-16 18:12 发表评论
]]>re: 统计数据库空间的使用情况http://www.cnblogs.com/Tianjon/archive/2009/01/16/1377214.html#1433199玉开玉开Fri, 16 Jan 2009 09:44:32 GMThttp://www.cnblogs.com/Tianjon/archive/2009/01/16/1377214.html#1433199
在一次teched上听讲师介绍一张表上的非聚集索引最好不要超过4个。

玉开 2009-01-16 17:44 发表评论
]]>re: 统计数据库空间的使用情况http://www.cnblogs.com/Tianjon/archive/2009/01/16/1377214.html#1433194love001love001Fri, 16 Jan 2009 09:42:16 GMThttp://www.cnblogs.com/Tianjon/archive/2009/01/16/1377214.html#1433194
love001 2009-01-16 17:42 发表评论
]]>re: Sql server 2005 找出子表树http://www.cnblogs.com/Tianjon/archive/2008/11/19/1336298.html#1374830xuyanxuyanWed, 19 Nov 2008 12:03:04 GMThttp://www.cnblogs.com/Tianjon/archive/2008/11/19/1336298.html#1374830先把所有的关系删掉，在drop表

xuyan 2008-11-19 20:03 发表评论
]]>re: Sql server 2005 找出子表树http://www.cnblogs.com/Tianjon/archive/2008/11/19/1336298.html#1374540mrfangzhengmrfangzhengWed, 19 Nov 2008 07:31:32 GMThttp://www.cnblogs.com/Tianjon/archive/2008/11/19/1336298.html#1374540
mrfangzheng 2008-11-19 15:31 发表评论
]]>re: Sql server 2005 找出子表树http://www.cnblogs.com/Tianjon/archive/2008/11/19/1336298.html#1374272ffffWed, 19 Nov 2008 03:51:27 GMThttp://www.cnblogs.com/Tianjon/archive/2008/11/19/1336298.html#1374272
ff 2008-11-19 11:51 发表评论
]]>re: Sql server 2005 找出子表树http://www.cnblogs.com/Tianjon/archive/2008/11/19/1336298.html#1374186风海迷沙风海迷沙Wed, 19 Nov 2008 02:48:49 GMThttp://www.cnblogs.com/Tianjon/archive/2008/11/19/1336298.html#1374186点开数据资源浏览器的数据库，找到你想看的表，在表名上面右键，
选择“查看对象依赖关系”,
选择查看“依赖于该表的对象”或“该表依赖的对象”

so easy that not need to frontpage.

风海迷沙 2008-11-19 10:48 发表评论
]]>