nabezo wiki

http://msdn.microsoft.com/ja-jp/library/ms189858%28v=SQL.90%29.aspx

SELECT
 so.name
 , ss.name
 , ss.auto_created
 , ss.user_created
 , ss.no_recompute
 , STATS_DATE(ss.object_id, ss.stats_id)
FROM
 sys.objects AS so
 LEFT JOIN
     sys.stats AS ss
 ON
     ss.object_id = so.object_id
WHERE
 type = ‘U’
ORDER BY
 so.name

declare @dbid smallint

set @dbid = DB_ID()

--インデックスの断片化(%)の検索【Simple Ver】
SELECT
b.name AS INDEX_NAME
, avg_fragmentation_in_percent as [全体の断片化％]
,a.*
FROM
sys.dm_db_index_physical_stats(@dbid, NULL, NULL, NULL, NULL) AS a
JOIN sys.indexes AS b ON
a.object_id = b.object_id
AND a.index_id = b.index_id
order by
avg_fragmentation_in_percent,
b.name