Spring 2010 Hardware Recommendations

Since I am very interested in various PC-based hardware, and I make an effort to stay current on new developments,...

Register For 24 Hours of PASS Event

The free 24 Hours of PASS event will be held on May 19-20, and includes 24 different one hour presentations...

Recap of April 2010 DMV a Day Series

Well, I managed to finish up my series that featured a DMV query every day during the month of April....

A DMV A Day – Day 30

The DMV for Day 30 is sys.dm_os_buffer_descriptors, which is described by BOL as:

Returns information about all the data pages that...

A DMV a Day – Day 29

The DMV for Day 29 is sys.dm_exec_connections, which is described by BOL as:
Returns information about the connections established to this...

A DMV a Day – Day 28

The DMV for Day 28 is sys.dm_io_pending_io_requests, which is described by BOL as:
Returns a row for each pending I/O request...

SQL Server 2008 and 2008R2 Diagnostic Information Queries

Since SQL Server 2008 R2 has gone RTM, and will be available on MSDN Subscribers on May 3, I thought...

A DMV a Day – Day 27

The DMV for Day 27 is sys.dm_tran_locks, which is described by BOL as:
Returns information about currently active lock manager resources....

SQL Server 2005 Diagnostic Information Queries (April 2010)

Since SQL Server 2008 R2 has gone RTM, and will soon be available for purchase, I am going to be...

A DMV a Day – Day 26

Well, we are on the final week of the DMV a Day series for the month of April. I will...