Rebuilding Indexes

• salmanucit

  SSC-Addicted

  Points: 400

  More actions

  September 17, 2008 at 9:52 pm

  #193027

  hi,

  i am very new in SQL Server. Can anyone help me by providing any documents about index rebuilding details (pros, cons, methods etc). I want this information about all index types.

  Thanks in advance

  Salman

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 18, 2008 at 1:50 am

  #873424

  Have you looked in Books Online. There's a fair bit in there. Look under ALTER INDEX.

  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

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  September 18, 2008 at 5:45 am

  #873521

  And do a search on the site here. There are a bunch of useful articles and scripts on this topic.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning