Table Access Order

Question

Table Access Order

Paul White

SSC Guru

Points: 150468
More actions
September 19, 2011 at 9:52 pm

#245087

Comments posted to this topic are about the item Table Access Order
Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Thanks for another superb question Paul.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Paul White SSC Guru Points: 150468 More actions · Answer 2

SQLRNNR (9/19/2011)
Thanks for another superb question Paul.

Thanks for leaving a comment - I had completely forgotten this was scheduled for today!

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

SQL Kiwi (9/19/2011)
SQLRNNR (9/19/2011)
Thanks for another superb question Paul.
Thanks for leaving a comment - I had completely forgotten this was scheduled for today!

The timing of the question is good. It gives me more info to research for an article I have been stumped on for a few months.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Robert Davis One Orange Chip Points: 28027 More actions · Answer 4

Even though i got it right, I wasn't 100% sure that it wasn't answer C. Great information!

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

M&M SSC-Insane Points: 21700 More actions · Answer 5

M&M

SSC-Insane

Points: 21700

September 19, 2011 at 10:56 pm

#1383627

Nice to see questions like this

M&M

Stuart Davies SSCoach Points: 19505 More actions · Answer 6

Good question - thanks

-------------------------------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

free_mascot One Orange Chip Points: 27164 More actions · Answer 7

Nice Question!!!

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Bex SSCrazy Points: 2437 More actions · Answer 8

Thank you very much for such an interesting question. Got the old grey matter going!

Bex

Kwex Default port Points: 1407 More actions · Answer 9

I got it wrong today ... as I completely forgot the role of "HASH" in the join statement. Grrrrr ....

Thomas Abraham SSChampion Points: 10761 More actions · Answer 10

Not only a great question, but a superb explanation. Thanks.

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

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 11

Good question, had to think a little. I was pretty sure it was A especially since there were no rows.

http://brittcluff.blogspot.com/

Cliff Jones SSChampion Points: 10547 More actions · Answer 12

Very interesting question. Thanks for the explanation.

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 13

Great question Paul!!!

Thanks!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Ken SSCoach Points: 17191 More actions · Answer 14

Ken

SSCoach

Points: 17191

September 20, 2011 at 7:56 am

#1383858

Nice question, thanks!

Table Access Order

Cookies on SQLServerCentral