This is the most clear and well-written summary that I've seen of the tradeoffs presented by the CAP theorem. Hopefully it clears up a lot of the confusion out there.

I think this is the tweet that prompted the post: http://twitter.com/JamesMPhillips/status/26502076366