Aug 19 2009
Correlate Session State Information With Cached Query Plans
Correlate session state settings with cached plans courtesy of the SQL Server Dynamic Management Objects.
Dynamic Management Objects
Jul 27 2009
Find All Logins With VIEW SERVER STATE Permissions
How do I determine if a login has the VIEW SERVER STATE permissions needed to query the Dynamic Management Views and Dynamic Management Functions in Microsoft SQL Server? A simple query…
Apr 26 2009
My Top 5 SQL Server Indexing Best Practices
What are the top 5 indexing best practices? That’s pretty subjective, but here you go. I’m sure the list would be different tomorrow or even five minutes from now.
Feb 17 2009
DMV Wish List
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 [...]
