in

SQL Server Community Blogs

Voices of the SQL Server Community
All Tags » SQL 2000 » Tips (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

  • 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 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems