Dare Obasanjo has a nice summary of a scaling talk given at ETech - lots of good stuff, but this bit at the end is especially interesting:

One big lesson learned about database scalability is that 3rd normal form tends to cause performance problems in large database. Denormalizing data can give huge performance wins.

Step one: Defeat the Architecture Astronauts :)