Grumpy Old DBA - Beware the darkside !

x64 Memory Issues - revisited

GrumpyOldDBA — Thu, 26 Jan 2012 08:19:00 GMT

It's funny how things seem to bob to the surface every so often, a bit like revivals of Musicals or the fact you know it's christmas becuase ET is on the TV again. Blake Morrision from the Ask the Performance Team has blogged about issues with...(read more)

Q. When is a HEAP not a HEAP ?

GrumpyOldDBA — Thu, 15 Dec 2011 20:56:00 GMT

A. When it’s on SQL Server. A very important part of Business Analysis is understanding the perceptions of users even if they haven’t clearly stated a requirement, so a SQL Server table without a clustered index is known as a heap ( in fairness I could...(read more)

A follow up to yesterday

GrumpyOldDBA — Tue, 22 Nov 2011 22:02:00 GMT

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...(read more)

Hello it’s your server calling

GrumpyOldDBA — Mon, 21 Nov 2011 20:12:00 GMT

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...(read more)

Table Variables and Parallel Plans

GrumpyOldDBA — Mon, 12 Sep 2011 19:52:00 GMT

I’m sure somewhere there must be carved into the side of a mountain those immortal words “ Well it seemed a good idea at the time!” ( with due homage to HHGTTG ) Hopefully there’s nothing in this post which you the reader will not know about already?...(read more)

Posts of Interest

GrumpyOldDBA — Mon, 05 Sep 2011 12:23:00 GMT

I don't make a habit of just posting links as I think it's like a form of cheating, however sometimes there are things I want to keep track of and I know If I put the link on my blog I'll find it again! so: a short one here; We've just...(read more)

Things you overhear !!

GrumpyOldDBA — Thu, 01 Sep 2011 15:31:00 GMT

"You can't get better than 90% can you?" " we need to disaggregate down the data"...(read more)

A New Record ( How many noughts ????????? )

GrumpyOldDBA — Sat, 16 Jul 2011 22:31:00 GMT

I have to say I thought I’d seen it all but this last week brought an event of such magnitude I may be contacting the Guinness Book of Records. OK that’s not true, but I’d like to! One of our production systems has to support a certain element of real...(read more)

Sometimes I really wonder !!!

GrumpyOldDBA — Thu, 14 Jul 2011 20:56:00 GMT

With all the best intentions in the world I did a review of some of our non production environments, what I realised was that we had not changed the default password on these environments for a number of years; essentially all user passwords are set to...(read more)

Bare Metal Restore Part 2

GrumpyOldDBA — Tue, 21 Jun 2011 18:46:00 GMT

I blogged previously about how Windows 2008 R2 has native "bare metal restore" http://sqlblogcasts.com/blogs/grumpyolddba/archive/2011/05/13/windows-2008-r2-bare-metal-restore.aspx , see the Core Team's blog post here; ...(read more)