Originally posted by: Pro Pete
2. Database activity analysis followed by review of the Fill factor being used for indexes - .
FILLFACTOR is a tricky one. For highly dynamic tables I use 70.
The problem is the uneven distribution of data in the keys. So even though 90 would be good at most part of the key sprectum, at dense places (like Smith for LastName), it would cause slow downs.
Dynamic table FILLFACTOR 80.
Average table FILLFACTOR 90.
You should check for index fragmentation to set your index REBUILD schedule: nightly, every other night, weekly, etc.
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2005 Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/