The query optimizer is truly amazing as well. I've seen it take complete madness as input and still perform reasonably. Now that you can keep targeting old behaviors until explicitly requested, upgrades have been much less concerning too.

Additionally columnstore support is awesome!