Browse by Tags

All Tags » SQL 2000 (RSS)
My old mate sp_recompile
12 October 2007 11:33
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 " Could not complete cursor operation because the table schema... Read More...
by ACALVETT | 2 comment(s)
Filed under: , , ,
Server level VLF report
25 July 2007 23:27
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 you see below. The Report code CREATE TABLE #VLFS ( fileid... Read More...
by ACALVETT | 2 comment(s)
Filed under: , ,
The joy of template parameters
15 July 2007 20:23
I thought I would do a quick blog about template parameters since I have been writing allot of standard deployment scripts for our 2005 builds and have used them extensively. So what are they? Well they are place holders and you would you use them in the same places that you would probably put a variable. The key difference comes when you assign the values. With... Read More...
by ACALVETT | 1 comment(s)
Filed under: , ,
What is that SPID doing?
27 March 2006 17:44
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 a SPID is executing we have to use DBCC INPUTBUFFER (). The... Read More...
by ACALVETT | with no comments
Filed under: , ,
A performance analysis example
15 January 2006 17:53
Last week i was dragged kicking and screaming away from my allocated SQL 2005 days to spend 2 days diagnosing performance problems on one of the firms Systems and write a report. Due to the sensitive nature of the data on the system it has been managed by another team and this was the first time i had looked at it. I thought i'd share my thought process to identifying... Read More...
by ACALVETT | with no comments
Filed under: , ,