Full disclosure - I'm a software engineer (if engineer is defined very broadly), not an admin. That said, I'm responsible for the care and feeding of our small (~8 people) engineering department's ...
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 ...