Order of Execution

Question

Post reply

Order of Execution

kranthikumar Gadde

SSC-Addicted

Points: 409
More actions
July 23, 2012 at 9:22 pm

#278273

Comments posted to this topic are about the item Order of Execution
July 24, 2012 at 4:51 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 29 total)

You must be logged in to reply to this topic. Login to reply

Jamsheer Ten Centuries Points: 1136 More actions · Answer 1

Thanks for the easy point.. I think the first and last options given are same..

Lokesh Vij SSChampion Points: 10836 More actions · Answer 2

Good question, but very easy options 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 3

Good question,but first and last option are the same.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 4

Easy one 🙂

*nitpicking mode on*

The question should ask "logical processing order", as the optimizer can throw things around in order to get better performance, as long as the result is the same as the logical processing order.

*nitpicking mode off*

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Sreepathi1987 Default port Points: 1425 More actions · Answer 5

Simple question.....

Is any answer verification doing before posting the questions ?

imarran SSC-Addicted Points: 489 More actions · Answer 6

nice simple question... the answer selection is a bit of a give away though 😉

but, good thing to know when trying to optimize queries.

SQLPhil SSCarpal Tunnel Points: 4204 More actions · Answer 7

Having only one option that started with FROM made it very straightforward. Useful to still refresh the memory with the sequence so thanks for the question (and easy point!) 🙂

Stuart Davies SSCoach Points: 19505 More actions · Answer 8

SQLPhil (7/24/2012)
Having only one option that started with FROM made it very straightforward. Useful to still refresh the memory with the sequence so thanks for the question (and easy point!) 🙂

+1

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Skanker Hall of Fame Points: 3059 More actions · Answer 9

Nice question though I would have prefered more than one option to have started with from as this would have made it more of a test.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 10

Thanks kranthi1.aprdc for the question. I see you are relatively new to the site. So good to see you jumping in with a QotD contribution. As others have suggested, this one might have been a bit too easy, with only one answer that started with "FROM". But, you're pointed in the right direction.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Mike Is Here Hall of Fame Points: 3348 More actions · Answer 11

Good question. It is good to know because you can use alias in the Order By clause but not the Where clause. The Select, and definition of an alias, is after where by before Order By

More answers starting with From would have been more trickier, I think that gives the answer away.

Dalton Moore SSC Eights! Points: 869 More actions · Answer 12

At least I was not the only one who noticed the first and third option were the same...

Dana Medley SSCertifiable Points: 6764 More actions · Answer 13

Thomas Abraham (7/24/2012)
Thanks kranthi1.aprdc for the question. I see you are relatively new to the site. So good to see you jumping in with a QotD contribution. As others have suggested, this one might have been a bit too easy, with only one answer that started with "FROM". But, you're pointed in the right direction.

+1

Everything is awesome!