Rebuild index

• shanila_minnu

  Hall of Fame

  Points: 3465

  More actions

  November 25, 2009 at 3:57 am

  #156442

  what is the query to rebuid the index in sql server 2000

• Schadenfreude-Mei

  SSChampion

  Points: 14083

  More actions

  November 25, 2009 at 4:02 am

  #1083890

  Have you done any research into this? A quick google search generally reveals all..

  Some reading:

  http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx

  http://www.mssqltips.com/tip.asp?tip=1367

  http://msdn.microsoft.com/en-us/library/aa258828(SQL.80).aspx

  Have fun 🙂

  Adam Zacks-------------------------------------------Be Nice, Or Leave

• SQL Editor

  SSCommitted

  Points: 1980

  More actions

  November 25, 2009 at 4:06 am

  #1083892

  DBCC DBREINDEX

  Example :-

  Rebuild all of the indexes on the authors table with 80% fill factor.

  DBCC DBREINDEX (authors, '', 80)

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 25, 2009 at 7:31 am

  #1084003

  Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.

  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