in

SQL Server Community Blogs

Voices of the SQL Server Community
All Tags » SQL 2000 (RSS)

Browse by Tags

  • 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

  • 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

  • The joy of template parameters

    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...
    Posted to Andrew Calvett (Weblog) by ACALVETT on 07-15-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

  • A performance analysis example

    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...
    Posted to Andrew Calvett (Weblog) by ACALVETT on 01-15-2006
Page 1 of 1 (5 items)
Powered by Community Server (Commercial Edition), by Telligent Systems