Dynamic Management Objects

May 25 2010

SQL Saturday #27 Wrap Up and Presentation Files Link

Thank you Portland, Oregon and all those associated with puting together and participating in SQL Saturday #27 on 5/22/2010. I would personally like to thank the anonymous, but freakishly tall gentleman who attended my last session of the day and was somehow able to reach the projector on the ceiling in order to restart it after [...]

By sqlagentman • Dynamic Management Objects, Presentations, SQL N00B Crew, SQL Saturday, Syndicated • • Tags: Dynamic Management Objects, Presentations, SQL N00B Crew, SQL Saturday

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.

By Timothy • Dynamic Management Objects, MSSQLTips, SQL, Syndicated • • Tags: DMF, DMV, dm_db_index_operational_stats, Dynamic Management Objects, SQL Server

Dynamic Management Objects

SQL Saturday #27 Wrap Up and Presentation Files Link

Non-Unique, Non-Consistent Data Returns From sys.dm_db_index_operational_stats

Want the Latest News? Subscribe:

SQLAgentMan Twitter Feed