A recent Visual Studio outage has been largely blamed on the cardinality estimator, but I think the query itself has a share of the blame.