Brian
Great article Brian, only things worth adding:
a) FK columns that are not indexed
b) Cluster indexes on identity columns
c) No collected or stale statstics
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"