Ali_SQLDBA (12/2/2009)
Most of my tables are either clusterd or non clustered.
Um, the distinction is clustered or heap. A nonclustered index is a separate structure and can sit on either tables with a clustered index or heaps
so as per your expertise... this is not a big deal for me to worry. Right?
Not for the small tables. For the large ones, it's still something that you need to do.
Also, do you recommend me t run rebuild offline scheduling an outage of the database every week.??
Offline, no. If your system is 24/7, then rebuild the indexes that you can online, if they need rebuilding, and only the ones that have to be rebuilt offline (because of LOB columns) get an offline rebuild.
Use a custom script rather than just a maintenance plan. I'm fond of this one - http://sqlfool.com/2009/06/index-defrag-script-v30/, lots of options to customise how much you rebuild, where the threshold are and other details.
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