Suggest me on tables

• mahesh.kumar

  Old Hand

  Points: 355

  More actions

  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?

• jacob sebastian

  SSChampion

  Points: 11822

  More actions

  October 10, 2008 at 12:02 am

  #883269

  Look for the following in BOL

  DBCC INDEXDEFRAG

  DBCC DBREINDEX

  .

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  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)