Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Tuesday, May 31, 2016 4:13 PM
Points: 2,107, Visits: 2,254
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: Thursday, June 2, 2016 7:14 AM
Points: 1,265, Visits: 13,601
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: Wednesday, June 22, 2016 2:06 PM
Points: 3,985, Visits: 2,267
Nice question, thanks!
Post #1177910
Posted Tuesday, September 20, 2011 9:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, June 14, 2016 1:11 PM
Points: 1,642, Visits: 2,035
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: Thursday, June 23, 2016 2:48 AM
Points: 2,195, Visits: 7,903
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: 2 days ago @ 9:22 AM
Points: 1,143, Visits: 2,768
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: Tuesday, June 21, 2016 1:36 PM
Points: 9,932, Visits: 11,340
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