outer apply vs cross apply

APPLY causes the right-side query to execute once per result in the left-side query.

CROSS only considers matching rows like INNER JOIN.

OUTER considers all rows in left-side query.

http://stackoverflow.com/questions/6726696/cross-apply-vs-outer-apply-speed-difference