DBCC Reindex and defragmentation

• Subhash-63067

  SSCarpal Tunnel

  Points: 4171

  More actions

  January 14, 2005 at 7:31 am

  #92100

  Hai,

  I am working as DBA support engineer, I was asked to do dbcc reindex and defragmentation. I have 300 tables in my database  and if i want to do reindex and defragment for each of these 300 table i will be time consuming.

  Is there any other way to do reindex and degrag for all the table together ?

  Please help

   

  
  subban

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 14, 2005 at 7:55 am

  #537470

  Have a look here:

  http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]