I am looking for some recommendations about maintaining an SQL server. I have 7 standalone PC’s (Windows 2000) running SQL Server 2000. There is alot of data flowing in and out of these machines. They are starting to slow down a bit. Apart from backing them up, is there some type of regular maintanence that is recommended to keep things humming along? What are you guys (and gals) doing?
