I just love the pic and tag line on Rottweiler being 9th smartest, mine was surprised anyone would enter such a beauty contest. Although, after working with a number of herding breeds, I can attest they may be the smartest across the board.
The intelligence of the herding breeds is pretty obvious. OTOH, I've seen dogs that are otherwise untrainable figure out things on their own. A lot of it is how the breed typically employs it's intelligence.
Heard a fascinating interview of the author of a book called "A Wolf in the Parlor". He contends that early domesticated dogs had a reduction of 10% of their cranial capacity when compared to their cousin the wolf. That has implications for intelligence, but I'm not sure that many people would say that a wolf is smarter than a border collie.