@RyanM it looks like it does the
outer apply
against the whole Tags table first and then applies the filter in the nested loop. It becomes a bit more clear if you use the showplan_text:
data.stackexchange.com/stackoverflow/query/1402138/… (bottom leaf nodes are executed first). This type of questions go well on Dba.se btw, if you want the nitty gritty details