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.
How do you steer those unfamiliar with SQL Server Reporting Services away from Microsoft Access before they hurt themselves or do harm to others?
The 24 Hours of PASS kicked off at 19:45 EST yesterday and has so far, with about three hours to go, been a great technical and educational success. Presenters have been solid for the most part, and there have been limited technical issues to work out early on. PASS’s own Tom LaRock has also been(…)