Click here to monitor SSC

Phil Factor's Phrenetic Phoughts

Simple-Talk columnist
The wilder shores of Transact SQL    Phil on Twitter   Phil on SQL Server Central  Phil on BOS

The DBA's Demise: a recitation.

Published Tuesday, June 13, 2006 9:25 AM

On a doorway in Dover
I once stumbled over
a programmer wrapped in a sheet
This poor prostrate nerd
didn't utter a word
as he lay there half-blocking the street

"From your face I can see
that you work in IT
what has brought you to this sorry state?"
This poor wretched geek
then started to speak
and told me his terrible fate

Cruel fortune had picked him,
as sad deadlock victim.
The conflict had left him for dead;
for wise men don't mess
with a deadlocked process
an incident DBAs dread.

"When I'm dead, on my harp
I shall play in C#"
On my terminal, happy I'll be.
I'm going offline
to a site that's divine
where all pizza and coffee is free."

"Insert into grave
select * from poor Dave
And put on my gravestone 'Raiserror!
a victim, one time
of a deadlocking crime"
Then he died with a look of sheer terror.

 

(lines written on getting the famous , and dreaded error 1205, 'Your server command (proces id xx) was deadlocked with another process and has been chosen as deadlock victim. Please re-run your command', whilst listening to 'The Streets of Loredo' on Internet Radio.)

 

Comments

 

links for 2006-09-09 -- Chip’s Quips said:

September 8, 2006 9:19 PM
You need to sign in to comment on this blog
Latest articles
A first look at SQL Server 2012 Availability Group Wait Statistics
 If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics... Read more...

SQL Server Prefetch and Query Performance
 Prefetching can make a surprising difference to SQL Server query execution times where there is a high... Read more...

SSIS Basics: Setting Up Your Initial Package
 When working with databases, the use of SQL Server Integration Services (SSIS) is a skill that often... Read more...

Checking Out SQL Backup Pro 7’s New Automatic Backup Verification
 Wouldn't it be great to offload the daily chore of checking the integrity of your production... Read more...

Chuck Lathrope: DBA of the Day
 Chuck Lathrope was a finalist for the Exceptional DBA of the Year award in 2009. We contacted him to... Read more...