Sep 11 2009
Non-Unique, Non-Consistent Data Returns From sys.dm_db_index_operational_stats
You would expect that a unique combination of database_id, object_id, index_id, and partition_number would be returned when calling sys.dm_db_index_operational_stats. Sometimes it does and sometimes it does not. SQL Server should not be a “sometimes” environment.
