>Every table in SQL Server should have a clustered index.
Not sure if I agree with this.... What about the case of a table used primarily as a link table (between two more meaningful tables with a many-to-many relationship)? If this table has very frequent inserts, but is queried infrequently, I would stay away from a clustered index. After all, the clustered index re-sorts the data with each insert, when necessary -- and the speed gain in querying may not be so important if, for instance, this is simply a quarterly report.
Most of the time, I see the advantage of a clustered index. But not as a rule.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell
