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 3, 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: Wednesday, August 20, 2014 8:26 AM
Points: 1,803, Visits: 2,168
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: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
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 @ 8:18 AM
Points: 3,909, Visits: 3,636
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: Yesterday @ 2:41 PM
Points: 1,258, Visits: 13,553
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: Yesterday @ 10:23 AM
Points: 3,299, Visits: 1,978
Nice question, thanks!
Post #1177910
Posted Tuesday, September 20, 2011 9:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 4, 2014 8:10 AM
Points: 1,635, Visits: 1,972
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 @ 10:20 AM
Points: 1,740, Visits: 6,366
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: Friday, August 1, 2014 9:46 PM
Points: 1,380, Visits: 2,684
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: Yesterday @ 5:58 PM
Points: 11,194, Visits: 11,141
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