Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Query Plan Execution Order Expand / Collapse
Author
Message
Posted Wednesday, October 26, 2011 9:07 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 12:15 AM
Points: 9,928, Visits: 11,207
Comments posted to this topic are about the item Query Plan Execution Order



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1196721
Posted Wednesday, October 26, 2011 9:15 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
Blew that one as did someone before me.

Learned a lot by reading your references - thanks for those.


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1196722
Posted Wednesday, October 26, 2011 9:48 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 2:38 PM
Points: 306, Visits: 346
Looks like I am the first to get it right!

Makes a change.

I am normally the last person to get it wrong.

Nice question, with lots of interesting articles.
Post #1196723
Posted Wednesday, October 26, 2011 11:45 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:03 PM
Points: 2,278, Visits: 3,806
This might be the toughest QotD.

Mohammed Moinudheen
Post #1196740
Posted Thursday, October 27, 2011 12:28 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 11:49 PM
Points: 1,484, Visits: 1,967
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

/T




Post #1196747
Posted Thursday, October 27, 2011 12:47 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 12:15 AM
Points: 9,928, Visits: 11,207
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
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1196752
Posted Thursday, October 27, 2011 1:13 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 11:01 AM
Points: 4,656, Visits: 11,131
Great question, Paul, and great explanation.
Looks like you tricked most of us (myself included).


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1196757
Posted Thursday, October 27, 2011 1:30 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 12:15 AM
Points: 9,928, Visits: 11,207
Gianluca Sartori (10/27/2011)
Great question, Paul, and great explanation.
Looks like you tricked most of us (myself included).

Thanks, but I want to say that I really really really didn't set out to trick anyone with this. It was intended as a follow-on question to my previous one (Table Access Order) but the scheduling meant they came much further apart in time than I intended. The formatting also got messed up in the explanation, but hey ho. Hopefully there's enough value in the learning point that I get away with it.




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1196763
Posted Thursday, October 27, 2011 2:06 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 18, 2014 7:05 AM
Points: 926, Visits: 1,316
Great question. I got it wrong but learned something which is a good start to the day.
Post #1196774
Posted Thursday, October 27, 2011 2:54 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 19, 2014 2:08 AM
Points: 1,808, Visits: 1,192
Nice one. I got it right - yay! - though I had to spend 20 minutes reading up (sorry work) first, as I was determined to get it right.

I think the setter was quite correct. If he had said which FINISHES executing first that would be a different matter.
Post #1196786
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse