Table Access Order

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Paul White » Table Access Order

35 posts, Page 2 of 4

««1 2 3 4 »»»

Table Access Order

Rate Topic

Display Mode

Topic Options

Author

Message

Kwex

Posted Tuesday, September 20, 2011 2:30 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, October 12, 2012 7:03 AM
Points: 249, Visits: 224

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

Post #1177692

Thomas Abraham

Posted Tuesday, September 20, 2011 5:27 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 2:04 PM
Points: 1,150, Visits: 1,455

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

Please don't go. The drones need you. They look up to you.

Post #1177779

Britt Cluff

Posted Tuesday, September 20, 2011 5:49 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,558, Visits: 247

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

http://brittcluff.blogspot.com/

Post #1177795

Cliff Jones

Posted Tuesday, September 20, 2011 7:51 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 3,397, Visits: 3,405

Very interesting question. Thanks for the explanation.

Post #1177904

rfr.ferrari

Posted Tuesday, September 20, 2011 7:51 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:51 AM
Points: 1,219, Visits: 13,507

Great question Paul!!!

Thanks!

rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!

Post #1177905

KWymore

Posted Tuesday, September 20, 2011 7:56 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 2,575, Visits: 1,533

Nice question, thanks!

Post #1177910

cfradenburg

Posted Tuesday, September 20, 2011 9:00 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:44 AM
Points: 1,555, Visits: 1,925

It's been good getting some of these harder questions that require knowing how SQL works. Thanks for taking the time to put them together.

Post #1177958

Toreador

Posted Tuesday, September 20, 2011 9:40 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356, Visits: 4,761

I was expecting to see "undetermined, could be either" as an option so guessed (wrongly as usual).
Learned something new - not sure how useful it is to know, but these things are always interesting :)

Post #1177994

Trey Staker

Posted Tuesday, September 20, 2011 9:43 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:52 PM
Points: 1,379, Visits: 2,626

Got it wrong Sad

Thanks for the question, eventhough I got it wrong I learned something. Great explanation!

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum

Post #1177998

Paul White

Posted Tuesday, September 20, 2011 9:53 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 8:43 PM
Points: 10,989, Visits: 10,533

Toreador (9/20/2011)

Learned something new - not sure how useful it is to know, but these things are always interesting :)

It depends. The average DBA can get by perfectly well with just a basic understanding of execution plans.

But who wants to be average?

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #1178014

« Prev Topic | Next Topic »

35 posts, Page 2 of 4

««1 2 3 4 »»»

Permissions