Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @table_name varchar(255)
- SET @table_name = 'Contact2'
- SELECT
- s.[OBJECT_ID],OBJECT_NAME(s.[OBJECT_ID]) as tablename
- ,si.name as indexname
- , s.avg_fragmentation_in_percent
- , s.fragment_count
- , s.page_count
- ,s.avg_fragment_size_in_pages
- FROM sys.indexes si inner join sys.dm_db_index_physical_stats (DB_ID(), null, null, null, null) s
- on si.object_id = s.object_id and si.index_id = s.index_id
- --WHERE OBJECT_NAME(s.[OBJECT_ID]) = @table_name
- ORDER BY s.avg_fragmentation_in_percent desc
Advertisement
Add Comment
Please, Sign In to add comment