The excuses my kids use to avoid bed, and how it affects you and your SQL Server

December 24, 2010 12:06 by Matt Whitfield

My kids are very creative. They can think up 101 excuses as to why they haven't gone to sleep yet, why they aren't able to sleep, and why they should get up at crack-sparrow-fart-o'clock and get in bed with me and my wife. When I say get in bed with, I really mean take over and shove.

It occurred to me that the excuses they give aren't dissimilar from some of the errors you can see in SQL Server, so I thought I would write a post on a more relaxed topic...

So, let's hear some of the excuses, their SQL Server equivalents, and the things you should do to avoid the problem:

Kid's excuseSQL Server errorNotes
'I can't get to sleep because of the noise from next door's TV''There is insufficient system memory in resource pool 'internal' to run this query'Ensure that the environment in which the server is running is suitable for the task at hand
'I need dog' (teddy which has been surgically attached since birth)'The procedure was called with an incorrect number of parameters'Things have to be just right - make sure you have everything you need to call a procedure, including all the parameters, otherwise things just won't go smoothly
'I've got a bad dream''Transaction was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction'Sometimes you just need to try again. Speak nicely to your SQL Server, reassure it, and run the query again
'I can't see''Assembly is not visible for creating SQL objects. Use ALTER ASSEMBLY to change the assembly visibility.'You need to set the visibility of the assembly before you can run DDL statements against it. It may be possible, of course, that you're not meant to be running DDL statements against it...
'I need some medicine because I'm poorly''BACKUP detected corruption in the database log. Check the errorlog for more information.'It's going to be a long night

Happy Christmas everyone!




12/24/2010 2:27:31 PM #


Pingback from topsy.comTwitter Trackbacks for                 The excuses my kids use to avoid bed, and how it affects you and your SQL Server         []        on

Add comment

(Will show your Gravatar icon)

  Country flag

  • Comment
  • Preview


Data Surf

Tag cloud


<<  March 2015  >>

View posts in large calendar