Browse by Tags

Cannot generate SSPI context

Now here's a slightly interesting point about this error. Although the kb does actually mention this reason for the error it is about the last thing on the article, a footnote, and it doesn't specifically word it to cover this scenario, and we all read the entire KB before doing anything - right...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 07-19-2008
Covering Clustered Indexes

I’ve noticed that of late I’ve become a bit more critical of a well known publication that I suspect many DBA’s read. I have subscriptions to a number of publications and for the ones that I pay for I’m generally quite content. I like paper / hard copy because I can make use of time where it’s just not...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 05-26-2008
Disappointing Review.

It's not very often I'm provoked into making a criticism of a respected publication, however there's nothing like being grumpy! I've published a number of posts about baselines, trending and performance analysis and I've been quick to remark when published examples don't really...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 04-17-2008
Only once every four years thank goodness!

I never cease to be amazed by what I discover within IT, mostly these days I'm more disappointed than anything else, I'm not a lover of the let's bash Microsoft about security patches or we should all use Linux / Open source as in the latter I'm sure if the most popular o/s was linux it would be full...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 02-29-2008
dbcc dropcleanbuffers - or maybe not

As a consequence of another action I was prompted to want to clear the buffer cache – or to be more precise I tried to clear the buffer cache. So stepping back, what happens if you install more memory than the combined size of your databases? Most would probably suggest that it’s a waste of time, however...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 02-22-2008
Would you buy Microsoft Support?

I've reached an interesting situation with microsoft support whereby I can't get past the first line telephone contacts. Under an incident/support I was recommended to use release 3179 for sql 2005 sp2 - this was for a 32 bit environment and I'm just now bringing 64bit environments on line and I want...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 09-19-2007
Analysing Indexes at SQLBits

Seems I've been selected to present at SQLBits on my work on Index Analysis. So a thankyou for those who voted for my presentation. I just noticed this post http://blogs.msdn.com/sqlcat/archive/2007/09/12/sqlcat-tracks-at-2007-sql-pass.aspx?CommentPosted=true#commentmessage and in true grumpy fashion...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 09-13-2007
dbmail puzzler

This had me scratching my head for a short while:- The first query sends a mail with a return status of 0 exec @return = msdb . dbo . sp_send_dbmail @profile_name = 'Any profile Will Do' , @subject = @subject , @body = @body , @query = @query , @query_result_separator = @separator , @exclude_query_output...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 08-01-2007
SQL Community is good to be part of.

It’s interesting to sometimes compare the flow of information about SQL Server to that available for other products. I’m currently working on an application which runs on SQL Server but by default / was developed with an ISAM back end. This particular application is very important for my client so discussions...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 06-19-2007
Not Thinking it through - the saga continues

The saga continues ……….. Here below are the previous posts which relate to the management of a production SQL Server ( by a third party ). We asked that the job which re-indexes the database be disabled until such time as the issue of the database mode was resolved .. sadly the backup job was disabled...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 01-04-2007

Page 1 of 2 (14 items) 1 2 Next >