Post reply

dbcc indexdefrag and dbcc dbreindex

  • April 17, 2009 at 12:45 am

    #155573

    Dear Friends,

    Wanted some idea about index tunning.....my question is like

    whats the difference between dbcc indexdefrag and dbcc dbreindex ?

    whats the benifits of both?

    and most important how to determine which to use when?

    Expecting some fruitful answers from all my teachers....

    Thanks

    Mithun

  • April 17, 2009 at 1:27 am

    #979444

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: [urlhttp://www.sqlservercentral.com/Forums/Topic699152-360-1.aspx][/url]

    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

  • April 17, 2009 at 1:32 am

    #979446

    Hello,,,

    It was not intended cross post, but i thought of that may be the performance tunning is the right section for it....

    I m really sorry , never wanted to waste any one's time.....

    Will take care in Future

    Regards,

    Mithun

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

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