Browse by Tags

All Tags » Best Practice » Diagnostics (RSS)
22 November 2011 22:02

A follow up to yesterday

As I have been asked,  here to tidy up yesterdays post is the procedure my startup procedure calls along with the logging table deployed in the DBA database. Just to muddy the water further I have routines for remotely calling the DBAMessages table...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
21 November 2011 20:12

Hello it’s your server calling

This is nothing exciting but I've always found this startup procedure  very useful. All this simple procedure does is send you an email if the SQL Service Starts. If your Server is a cluster it will tell you which node you're on. -- On it's...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
16 June 2010 20:15

So which null equals this null, that null? maybe this null, or is it this null?

Tuning takes many routes and I get into some interesting situations and often make some exciting finds, see http://sqlblogcasts.com/blogs/grumpyolddba/archive/2010/05/17/just-when-you-thought-it-was-safe.aspx for an example. Today I encountered a multitude...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
15 May 2010 12:20

Did I back that file up ?

As part of some diagnostics I was wishing to check if a particular file had been locked by a backup process whilst I was trying to copy it. So I put a request into the DataCentre for a list of files backed up and time when they were backed up, seems reasonable...
Posted by GrumpyOldDBA | 19 comment(s)
Filed under: ,
09 June 2008 18:54

Dates - especially when SQL Server can't be British!

Just like memory config dates never seem to go away and I've had some discussions with our BI team recently on why things were not working quite as expected, especially on the 13th of the month; and I noticed the same issue had arisen for a member...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
26 October 2007 10:09

Do you use the float datatype?

I thought I’d perhaps blog about this although I don’t truly think this is of any real significance unless you like to use the flat datatype, which I hope you don’t. I had restored a production backup onto a development box and the guys had run a couple...
Posted by GrumpyOldDBA | 20 comment(s)
Filed under: ,
26 June 2007 12:55

Not thinking it through – the post mortem

I just thought I’d round off my series of posts concerning my first experience of an outsourced data centre. http://sqlblogcasts.com/blogs/grumpyolddba/archive/2007/01/04/not-thinking-it-through-the-saga-continues.aspx It really got to the stage of almost...
Posted by GrumpyOldDBA | with no comments
Filed under: ,