Posted by Erland Sommarskog on 10/02/35 11:45

pb648174 (google@webpaul.net) writes:
> The total database size is less than half a gig. Most of the time the
> data is being read, with maybe 20% of the time being inserts and
> updates. I would like an expert to give me the link so I know I'm not
> getting the wrong thing.. I see plenty of stuff out there but am unsure
> what the right thing to do is. I was hoping there would be
> functionality in SQL 2005 that would just handle it.

If the database is that small, I would set up job that just loops
sysobjects and reindex every table in sight. It's not worth the effort
to anything more sophisticated.

The reason that we exempt some tables is from reindexing is mainly to
reduce execution time for the job.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]