Tag Archives: SQL Server 2005

Waitresource Key

Posted on January 24, 2012 by thomasrushton

I was watching a server this morning, making sure that there was nothing untoward going on, and I caught sight of a LCK_M_S waittype with a very long number in the Resource column: KEY: 26:72057594819903488 (6b0068a71fb9). I watched a bit … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment

Adventures with DBCC and Database Upgrades

Posted on November 1, 2011 by thomasrushton

We have (had?) an application that has been retired (Hurrah!).  However, even though it has been retired, there is still the occasional request to extract data from this database, which was hosted on a SQL2000 SP3a server.  So what I’m … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | 3 Comments

Lazy programming from MS? Surely not…

Posted on December 21, 2010 by thomasrushton

Another vignette from SQL Server 2005 Management Studio showing a possible lack of attention to detail somewhere… (Speaking of lack of attention to detail, I can’t remember which version of the SSMS had this bug.  I suspect it was RTM, … Continue reading →

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , , | Leave a comment

Unable to launch Activity Monitor.

Posted on November 30, 2010 by thomasrushton

It all started so innocently. A SQL Server 2005 installation.  An installation of SQL Workbench, sorry, “Microsoft SQL Server Management Studio.”  And a need to find out what’s going on.  Click, click, click – Activity Monitor.  Double-click.  Uh-oh. (Incidentally, why … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | 2 Comments

SQL Server 2005 RTM Maintenance Cleanup FAIL

Posted on October 18, 2010 by thomasrushton

A recent question on AskSSC reminded me of a little issue affecting SQL Server 2005’s maintenance plans; specifically, the Maintenance Cleanup task. Those of you (un)lucky enough to still be running SQL 2005 RTM may well be aware of this, … Continue reading →

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , | Leave a comment

SQL Server 2005 SP3 Installation problem

Posted on August 12, 2010 by thomasrushton

I knew it was all going too smoothly… I’ve just been upgrading a few instances of SQL Server 2005 to SP3 (I know, I know…).  Things have been mostly going well, until I got to one server that threw up … Continue reading →

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , | 1 Comment