Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ps.database_id, ps.OBJECT_ID,
- ps.index_id, b.name,
- ps.avg_fragmentation_in_percent
- , ps.*
- FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS ps
- INNER JOIN sys.indexes AS b ON ps.OBJECT_ID = b.OBJECT_ID
- AND ps.index_id = b.index_id
- WHERE ps.database_id = DB_ID()
- ORDER BY ps.OBJECT_ID
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement