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!

Tags:

thoughts

Comments

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

pingback

Pingback from topsy.comTwitter Trackbacks for                 The excuses my kids use to avoid bed, and how it affects you and your SQL Server         [atlantis-interactive.co.uk]        on Topsy.com

topsy.com

Add comment



(Will show your Gravatar icon)



  Country flag

biuquote
  • Comment
  • Preview
Loading



CAPTCHA image




SQL Everywhere

Tag cloud

Calendar

<<  September 2014  >>
MoTuWeThFrSaSu
25262728293031
1234567
891011121314
15161718192021
22232425262728
293012345

View posts in large calendar