Search This Blog

Wednesday, March 6, 2019

SQL Query to Get Table Index fragmentation

Query:

SELECT * FROM sys.dm_db_index_physical_stats(dbid, table_objectid, NULL, NULL , 'LIMITED')
ORDER BY avg_fragmentation_in_percent DESC

No comments:

Post a Comment