sufiyan.sarguroh (6/8/2012)
Hi All,The dynamic view sys.dm_db_index_physical_stats gives us the external fragmentation value in percent. Is there any way we can find the internal fragmentaion value ? And does the index rebuild/reorg reduce internal frag too ?
I am not sure, but as per my knowledge index rebuild will remove internal frag, as in Index rebuilding it will create new index by droping old index.