• This bug is probably also a reason why partitioning is not that commonly used:

    http://connect.microsoft.com/SQLServer/feedback/details/240968/partition-table-using-min-max-functions-and-top-n-index-selection-and-performance

    ... it would be a nice feature however, if it worked.