Post reply

Stored Procedure

  • March 7, 2009 at 11:23 pm

    #94730

    Hi,

    Please tell me what type of stored procedures are called Housekeeping Stored procedures.I have some SPs for taking backups,monitoring the database space,datafile space,index rebuilding and intergrity.

    Thanks in advance

  • March 8, 2009 at 10:02 am

    #955676

    Those would certainly qualify as "housekeeping" stored procedures. I'm curious... why the question?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • March 8, 2009 at 11:09 am

    #955680

    sudarram (3/7/2009)

    Please tell me what type of stored procedures are called Housekeeping Stored procedures.

    Depends who you ask. That's not a term with a universally accepted definition.

    Why is it important to you?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply