Reindex all indexes online or offline depending on day of week.

• spongemagnet

  SSCrazy

  Points: 2812

  More actions

  October 3, 2008 at 3:30 pm

  #193646

  Comments posted to this topic are about the item Reindex all indexes online or offline depending on day of week.

  
  -Ken

• sandy_1006

  SSC Eights!

  Points: 953

  More actions

  October 21, 2008 at 3:53 am

  #887498

  hi Ken,

  Mine is production environment ,EnterpriseEdn SQL Server2005 instance is running.

  Fragmentation of tables(both heap and non heap) indexes in one of databases(App 10GB in size) is so high, that it shows above 90%fragmentation

  Please do suggest or help me literally as to how to go ahead and do the index rebuilding online with out affecting the services.

  Also i have queries whiel doing rebuilding :-

  What happens if a table has more than one index?

  Also if the tables have dependancies?

  Also do i need to disable clustered/nonclustered indexes of table while rebuilding.

  attached Here with the sample data of fragmentation

  Thanks in Advance,

  Sandy

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 16, 2016 at 7:21 am

  #1879242

  This is a useful script, thanks.