There is an external fragmentation occured on one of table and after running DBCC REINDEX, DBCC INDEXDEFRAG AND UPDATE STATISTICS also the fragmentation is still there with same percentage.
I am checking fragmentation from this dmv dm_db_index_physical_stats and column avg_fragmentation_in_percent is still having value 80 only.
my question is; Why DBCC REINDEX is not working ?
Suggestions will be appreciated..........
Thanks & Regards