Here is a great article from a former co-worker, Khaja on the performance benefits of using Cross Apply in sub-queries.