'Duplicated records showing up when i ran sys.dm_db_index_physical_stats with same index_id,partition_number,index_depth and level but diff frag ¿why?
I'm getting the next case. Using "sys.dm_db_index_physical_stats" for an specific, DB and table i'm obtaining duplicated rows with different fragmentation in the same partition,index_id,index_level and depth... ¿somebody knows what is the reason? and what i ve to do if i want to obtain only the one fragmentation for an specific partition?
the query im using for is the next:
SELECT * from sys.dm_db_index_physical_stats (DB_ID(N'DB_Name') ,OBJECT_ID(N'Table_Name'), 1, NULL , 'LIMITED')
WHERE [alloc_unit_type_desc] = 'IN_ROW_DATA'
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|