Interesting question. "The ALL will be applied to all values, with the NULL eliminated" may be incorrect. I tried running the same query without COUNT() and found NULL value in the result set. 
SELECT
ALL tc.varcharcol
FROM dbo.TheCounts AS tc