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 ««1234»»»

Table Access Order Expand / Collapse
Author
Message
Posted Tuesday, September 20, 2011 2:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 03, 2013 1:55 AM
Points: 298, Visits: 236
I got it wrong today ... as I completely forgot the role of "HASH" in the join statement. Grrrrr ....
Post #1177692
Posted Tuesday, September 20, 2011 5:27 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:35 AM
Points: 1,625, Visits: 2,034
Not only a great question, but a superb explanation. Thanks.

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1177779
Posted Tuesday, September 20, 2011 5:49 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,588, 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
Posted Tuesday, September 20, 2011 7:51 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:10 PM
Points: 3,766, Visits: 3,584
Very interesting question. Thanks for the explanation.
Post #1177904
Posted Tuesday, September 20, 2011 7:51 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:25 PM
Points: 1,253, Visits: 13,546
Great question Paul!!!

Thanks!



rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1177905
Posted Tuesday, September 20, 2011 7:56 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 9:46 AM
Points: 3,150, Visits: 1,900
Nice question, thanks!
Post #1177910
Posted Tuesday, September 20, 2011 9:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 7:13 AM
Points: 1,634, Visits: 1,964
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
Posted Tuesday, September 20, 2011 9:40 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:26 AM
Points: 1,658, Visits: 6,002
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
Posted Tuesday, September 20, 2011 9:43 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, March 10, 2014 3:52 PM
Points: 1,380, Visits: 2,681
Got it wrong

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
Posted Tuesday, September 20, 2011 9:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:59 AM
Points: 11,168, Visits: 10,931
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 »

Add to briefcase ««1234»»»

Permissions Expand / Collapse