some of our tables indexs are badly fragmented - up to 90% !
so i am going to set up a new indexing routine, and would appreciate some input..
the sql server is basically unused at the weekends apart from backups etc so i was thinking that i may as well do a full rebuild on all indexs every weekend regardless of fragmentation? i know from reading on the subject that a rebuild isnt deemed necessary unless frag >=30% and a reorganise when > 5% <30%
but will it have any negative effect if i do the full rebuild every week?