>Should all my tables have a clustered index ? Are there cases where I should avoid this ?

IMO, yes. The BIG question is in deciding the column(s) to index. The BOL has lots of good information. Start with the topic Table and Index Architecture and read all subtopics.

-Mike