This week, after seeing a lot of the DMV enhancements made in SQL Server 2008 R2 SP1, I thought I would take a look at some dynamic management view/function requests.
Page split personality Michael Zilberstein blogged on Monday about how Extended Events and the transaction log differ in the way they report page split information, and that it ...

I have been involved in several discussions over the past week involving getting more diagnostic information out of the DMVs in SQL Server 2008 and beyond.
Yesterday, I asked for procedure recompiles to be tracked in the new sys.dm_exec_procedure_stats DMV:
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=388218
Today, ...

A frequently asked question that surfaced again today is, ''how do I see when my data has been accessed last?'' SQL Server does not track this information for you. SELECT triggers still do not exist. Third party tools are expensive and can incur unexpected overhead. And people continue to be reluctant or unable to constrain ...

Yesterday Denis Gobo told you about 33 new DMVs in SQL Server 2008;
previously, I had noticed that a few of the existing DMVs from 2005 had
changed slightly. So, Denis sparked my curiosity, and I ran the
following query on a recent build of SQL Server 2008, which had a linked server pointing to SQL Server 2005:
SELECT s1.vn, s1.cn ...