Monthly Archives: April 2010

A DMV a Day – Day 22

Posted on April 21, 2010 by Glenn Berry

The DMV for Day 22 is sys.dm_exec_query_memory_grants, which is described by BOL as: Returns information about the queries that have acquired a memory grant or that still require a memory grant to execute. Queries that do not have to wait … Continue reading →

Posted in SQL Server 2008 | Leave a comment

Big SQL Server Announcement This Morning at 7:30AM PDT

Posted on April 21, 2010 by Glenn Berry

Microsoft’s Ted Kummert and Tom Casey are holding a public conference call this morning at 7:30AM Pacific time, where: Microsoft Corp. is holding a teleconference with Senior Vice President Ted Kummert and General Manager of Business Intelligence Tom Casey, who … Continue reading →

Posted in SQL Server 2008 R2 | 2 Comments

A DMV a Day – Day 21

Posted on April 20, 2010 by Glenn Berry

The DMV for Day 21 is sys.dm_os_ring_buffers, which is helpfully NOT described by BOL as: The following SQL Server Operating System–related dynamic management views are Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Ooh, that sounds … Continue reading →

Posted in SQL Server 2008 | 2 Comments

Staying Current with SQL Server Builds

Posted on April 20, 2010 by Glenn Berry

There was some conversation on Twitter about how to get notification when new Cumulative Updates are released for SQL Server 2005 and SQL Server 2008. Aaron Bertrand (blog | twitter) had a good post that discusses some of the ways … Continue reading →

Posted in SQL Server 2008 | Leave a comment

A DMV a Day – Day 20

Posted on April 19, 2010 by Glenn Berry

The DMV for Day 20 is sys.dm_exec_cached_plans which is described by BOL as: Returns a row for each query plan that is cached by SQL Server for faster query execution. You can use this dynamic management view to find cached … Continue reading →

Posted in SQL Server 2008 | Leave a comment

SQL Server 2005 SP3 Cumulative Update 9 (Build 4294)

Posted on April 19, 2010 by Glenn Berry

Microsoft has released SQL Server 2005 SP3 Cumulative Update 9, which is Build 4294. I count 13 fixes in this build. There is no corresponding cumulative update for SQL Server 2005 SP2, since SP2 is no longer a supported service … Continue reading →

Posted in SQL Server 2005 | Leave a comment

A DMV a Day – Day 19

Posted on April 18, 2010 by Glenn Berry

The DMV for Day 19 is sys.dm_os_wait_stats, which is described by BOL as: Returns information about all the waits encountered by threads that executed. You can use this aggregated view to diagnose performance issues with SQL Server and also with … Continue reading →

Posted in SQL Server 2008 | Leave a comment

Spring Planting 2010

Posted on April 18, 2010 by Glenn Berry

Spring fever is running hot here in Parker, Colorado, after a long winter. Last year, I put in a Square Foot Garden, and I added a few small containers with tomatoes. This year, I have added a second Square Foot … Continue reading →

Posted in Hobbies | 5 Comments

Goggle PowerMeter Update

Posted on April 18, 2010 by Glenn Berry

As I have mentioned before, I have a TED 5000 electric power monitor installed in my house that monitors and records my electric power usage on a second by second basis. The TED 5000 can also upload data to Google … Continue reading →

Posted in Computer Hardware | Leave a comment

A DMV a Day – Day 18

Posted on April 17, 2010 by Glenn Berry

The DMV for Day 18 is sys.dm_clr_tasks, which is described by BOL as: Returns a row for all common language runtime (CLR) tasks that are currently running. A Transact-SQL batch that contains a reference to a CLR routine creates a … Continue reading →

Posted in SQL Server 2008 | 1 Comment