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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, April 20, 2015 9:14 AM
Points: 305, Visits: 240
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, June 24, 2015 5:03 PM
Points: 2,106, Visits: 2,251
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: Monday, November 10, 2014 12:05 PM
Points: 3,969, Visits: 3,648
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 @ 11:20 AM
Points: 1,262, Visits: 13,574
Great question Paul!!!

Thanks!



rfr.ferrari
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!
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: Thursday, July 16, 2015 3:38 PM
Points: 3,659, Visits: 2,136
Nice question, thanks!
Post #1177910
Posted Tuesday, September 20, 2011 9:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, July 1, 2015 10:38 AM
Points: 1,639, Visits: 2,011
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:13 AM
Points: 2,003, Visits: 7,267
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: Today @ 2:53 PM
Points: 1,142, Visits: 2,713
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 4:12 AM
Points: 9,932, Visits: 11,285
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
SQLPerformance.com
SQLblog.com
@SQL_Kiwi
Post #1178014
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse