Browse by Tags

Changing the Data Files Location after Installation

The other day i wanted to change the "Data Files" location for a 2005 database engine installation and a 2005 Analysis Services installation which you can specify under the advanced options during installation. I quickly found out that there appears to be no documented ways to do this other...

Posted to Andrew Calvett (Weblog) by ACALVETT on 08-10-2008
SSAS 2005 – Server side tracing starter kit

Analysis services 2005 (SSAS) added the ability to trace server side events and i have used this feature a number of times. To date i had always used the profiler gui to do the SSAS tracing but today i found myself needing to initiate and manage a trace with scripts. The good news is that it can be done...

Posted to Andrew Calvett (Weblog) by ACALVETT on 04-07-2008
Transaction log backup deadlock

Recently we started to see deadlock errors when backing up our transaction logs. The "important" part of the error is shown below. Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still...

Posted to Andrew Calvett (Weblog) by ACALVETT on 02-19-2008
SSMS Log file viewer and Deadlock Graphs

Firstly I must say a big thank you to Microsoft for the new deadlock trace flag 1222. Compared to the trace flag output for 1204 & 1205 that you had to use in SQL 2000 it’s a walk in the park to interpret. Anyway, back to the post at hand! This is a quick FYI as i`m not going to go through how to...

Posted to Andrew Calvett (Weblog) by ACALVETT on 01-23-2008
The Job whose owner kept coming back......

I thought i would share this little quirk about the SQL Agent jobs for maintenance plans. One of our members of staff had left and we had the usual case of a few jobs failing with: "Unable to determine if the owner (DOMAIN\xxx) of job <JOB_Name> has server access (reason: error code 0x534. [SQLSTATE...

Posted to Andrew Calvett (Weblog) by ACALVETT on 12-30-2007
My old mate sp_recompile

As soon as i saw the error messages in the logs i thought to myself "Oh my, that did not happen in testing" (ok, maybe it was more colourful than that). We were creating a clustered index on a tiny little table and the index went through fine. However, the application started to generate the message...

Posted to Andrew Calvett (Weblog) by ACALVETT on 10-12-2007
Top 10 Hidden Gems in SQL Server 2005

I just heard about this very interesting document (it was published in January, though). It defiantly worth looking at Top 10 Hidden Gems in SQL Server 2005 Cheers, Itay

Posted to The Premiers (Weblog) by ThePremiers on 08-01-2007
Server level VLF report

I read Tony Rogerson's blog on Virtual Log Files today and it reminded me that i really should knock up a little report to list all databases on a server and the number of VLF's per database. Since I had been busy writing some other Operational reports I was in the right frame of mind so knocked up what...

Posted to Andrew Calvett (Weblog) by ACALVETT on 07-25-2007
What is that SPID doing?

This is certainly not a new topic but something that i felt was worth revisiting and reminding people about, especially because i find many people are not aware of the ability to extract the statement within a stored procedure being executed. So, prior to SQL 2000 SP3, when we want to know what code...

Posted to Andrew Calvett (Weblog) by ACALVETT on 03-27-2006
2005 - Alter failed for server XXX

Thats exactly what i thought!! What the hell does that mean? Well, for me this occured in the context of running the maintenance plan integrity check task. It had been running fine for weeks but suddenly boom every time it ran it would fail with "Alter failed for server XXX". There was no obvious reason...

Posted to Andrew Calvett (Weblog) by ACALVETT on 02-13-2006

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