Phil Factor's Phrenetic Phoughts

Simple-Talk columnist
The wilder shores of Transact SQL

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

















<June 2006>
SuMoTuWeThFrSa
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678
On the Trail of the Expanding Databases
 It is sometimes difficult for other IT people to understand the constraints that DBAs have to work... Read more...

SQL Server 2008: The New Data Types
 Brad continues his helicopter-level view of the most interesting new features of SQL Server 2008 with a... Read more...

Reporting on Mobile Device Activity Using Exchange 2007 ActiveSync Logs
 In this new column giving practical advice on all things Sys Admin related, Ben Lye takes on the often... Read more...

The Bejeweled Puzzle in SQL
 Alex Kozak provides another SQL puzzle to hone your SQL Skills with.  Read more...

Using Powershell to Generate Table-Creation Scripts
 For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for... Read more...