tommyh (10/27/2011)
Going to stick my neck out and say that its wrong.Yes the stream aggregate gets called first... but it hasnt finished. So is the important part which gets called first or which gets finished first? Personally i think its the part that gets finished first thats important (or more precisly the thing that performs its purpose first). I cant say a function has been executed when it hasnt actually done anything.
Could be a language thing though that i put a different meaning into "executes" then everyone else 🙂
The learning point today was about execution order (hence the title). Query plans are pipelines, and the intention was to highlight something that most people misunderstand about that. I'm sorry the way I phrased it differs from your intuitive understanding of 'executes', if I could give you your two points, I would. That's not to say that I agree with you (I don't) but points are free, and I like people to be happy 🙂
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi