Migrating Cardinality Eestimation Posts from Previous Blog
Ian had a blog that contains a number of interestig tips/tricks, mostly about cardinality estimation during query optimization.
I've chatted with him and will be migrating/expanding some content over to the team site.
If you have specific requests from topics in his Blog that would interest you, post them up and I'll find someone on the team to work on them.
Ian's Blog: http://blogs.msdn.com/ianjo/default.aspx