Post reply

Suggest me on tables

  • October 9, 2008 at 11:35 pm

    #883263

    Hi,

    Thanks for your immediate reply..

    Could you pls provide what are the dbcc commands i should look for..

    While doing rebuild the index there wont be any data loss on the time?

    Do i have to use this dbcc commands manually or any automatic process available?

  • October 10, 2008 at 12:02 am

    #883269

    Look for the following in BOL

    DBCC INDEXDEFRAG

    DBCC DBREINDEX

    .

  • October 10, 2008 at 5:09 am

    #883347

    jacob sebastian (10/10/2008)

    Look for the following in BOL

    DBCC INDEXDEFRAG

    DBCC DBREINDEX

    One more... DBCC SHOWCONTIG. It produces a report on whether the index(s) on a table actually need to be defragged. In Books Online, the entry for DBCC SHOWCONTIG even has an example of how to setup code to make a defrag job for an entire database.

    --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)
    Intro to Tally Tables and Functions

Viewing 3 posts - 16 through 17 (of 17 total)

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