Understand how often to rebuild and reorganize indexes

Periodic rebuilding or reorganizing of indexes is a normal part of maintaining a database. There are rules of thumb (though not hard and fast numbers) for the points at which these should occur. Consult SQL Server web resources for more information.