Browse by Tags

All Tags » File Under Grumpy (RSS)
15 December 2011 20:56

Q. When is a HEAP not a HEAP ?

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...
Posted by GrumpyOldDBA | with no comments
Filed under:
01 September 2011 16:31

Things you overhear !!

"You can't get better than 90% can you?" " we need to disaggregate down the data"
Posted by GrumpyOldDBA | with no comments
Filed under: ,
14 July 2011 21:56

Sometimes I really wonder !!!

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...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
18 April 2011 22:50

Not thinking it through - the sequel ( Part 1 )

A few years ago I did a series of posts entitled "Not thinking it through" which were really cause and effect situations where an attempt to resolve a problem only caused another problem. If you like to consider the route between business and...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under:
11 April 2011 20:41

Windows doesn't like Squirrels ?

Strange goings on when setting a sevrice account password ^^ I was setting a service account for a dev SQL server and wished to change the account password from that which it had been created with. I can list all of this as I'm not giving away server...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
22 March 2011 11:42

Partitions and FullText - not an option

I'm a strong advocate of partitioning having deployed solutions through SQL 2000, 2005 and 2008, in fact federated servers is about the only aspect of partitioning which I've not deployed in a production environment. Recently I've been applying...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
30 September 2010 22:05

Rowversion vs Timestamp !! what’s the word then microsoft?

I like to promote all things SQL Server whenever I can and when the subject of allocating some time to maintenance of our applications was raised I was quick to suggest we could replace the numerous Timestamp columns with Rowversion so that we future...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
16 July 2010 12:59

I think I'm fitting the OLD in GrumpyOldDBA

I try to keep up with a posts on a number of blogs both SQL Server and Windows and it's interesting to see the same subjects being raised time after time in, especially, the SQL Blogs. Now I don't see this as bad, other than it's duplication...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under:
03 June 2010 12:36

Now you know it's true !

Grumpy is good - official !! http://news.bbc.co.uk/1/hi/8339647.stm
Posted by GrumpyOldDBA | with no comments
Filed under: ,
23 April 2010 07:44

Why do I bother with RAID 10 ?

Before I post anything I just want to clarify what I mean by RAID 10 , this is sets of mirrored pairs that have been striped as against a RAID 0 which has been mirrored. I've just had a disk failure in the data array for one of my dev servers, it's...
Posted by GrumpyOldDBA | 13 comment(s)
Filed under: , , ,
More Posts Next page »