As Andy already mentioned, missing indexes in the graphical plan is a huge plus. They are usually pretty accurate or pretty close making it pretty helpful.

I will have to say that sparse columns, for those that have a lot of data, can be a pretty well overlooked feature. There can be some great savings there if the situation is right.