We updated an app recently which imposed a lot more clustered indexes then had previously been there. We also have a weekly index rebuild which I'm assuming is now running super long because of those ...

I wanted to get some suggestions for scheduled maintenace on a SQL Server 2000 box that is hosting a relatively small database (<=13GB). I already have a weekly integrity check that reorganizes data ...