From the Wall Street Journal: Three Myths on Boosting Search Engine Rankings.

Short Version-

Myth 1. You can be guaranteed consistently high rankings.

Myth 2. I need to submit my Web site to every search engine out there.

Myth 3. Repeating keywords will increase my site's rankings.

The article has a lot of good anecdotes. I recommend reading it.