Jul 12 2010
It’s no secret that Louis Davidson and I are working on a book for Red Gate on Dynamic Management Views. Good news is that we’re close… oh so close. In the meantime Red Gate has published a DMV Starter Pack that includes exerpts from our book along with content from our Technical Editor: fellow SQL [...]
Sep 11 2009
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.
Feb 17 2009
Just today, Tony Davis editorialized at Simple-Talk.com on the topic of SQL Server Dynamic Management Views (and Functions) and the complexity that lies within. His opinion, and those of many of others that commented to date are that the DMVs/DMFs, while valuable, are overly-complex, incomplete, and inconsistent in their current state. I for one, am one of [...]
