I also love Paul's articles on APPLY and would second that suggestion. If you own or have access to Microsoft SQL Server 2012 High-Performance T-SQL functions by Itzek Ben-Gen there is a great section called "Improved Parallelism with APPLY". It's a just a few pages of some very valuable information.
-- Itzik Ben-Gan 2001