Understanding and Using APPLY in SQL Server

I've read an interesting article by Paul White on Understanding and Using APPLY:
Understanding and Using APPLY (Part 2)