February 20, 2012 at 5:26 am
Hardly can imagine adding UNIQUE on a column just becase the column takes part in some join.
February 20, 2012 at 6:53 am
DugyC (2/20/2012)
Ah! the disappointment of thinking you've done really well and ticked all the right boxes to then be told you are wrong!... however, faith can then be restored by clicking on Join the discussion and finding that you were right after all.Phew 😀
+ 1. And here I thought Monday was gonna start bad. 🙂
February 20, 2012 at 6:58 am
now it seems to select all of them.
Except the linked article doesn't mention anything about uniqueness constraints.
February 20, 2012 at 7:11 am
Kameswari Aravindh (2/20/2012)
:crying:I want my Points back
<AOL Mode> ME TOO! </AOL Mode> 😉
(But really, the reading I did before answering made it all worth while! Thank you for the question.)
February 20, 2012 at 7:12 am
mtassin (2/20/2012)
now it seems to select all of them.Except the linked article doesn't mention anything about uniqueness constraints.
Actually, no I just misread it.
Make sure that statistics exist on the columns that are being joined or grouped., If statistics exist on the columns, update them., Use a different type of join. For example, use a MERGE or LOOP join instead, if appropriate., Apply Unique key constraint on the column.
Except that this link. http://technet.microsoft.com/en-us/library/ms190736.aspx says this
Make sure that statistics exist on the columns that are being joined or grouped.
If statistics exist on the columns, update them.
Use a different type of join. For example, use a MERGE or LOOP join instead, if appropriate.
Increase available memory on the computer. Hash recursion or bailout occurs when there is not enough memory to process queries in place and they need to spill to disk.
Which I was proud that I had actually figured out the right answers for this (once I read what a hash bailout is).
February 20, 2012 at 7:23 am
:ermm: Another question somebody should proofread before posting :sick:
Unique constraint seemed false to me at a glance :unsure: so I searched a bit and found the same article that is given as reference :hehe:
Result has been :pinch: a big surprise :doze:
February 20, 2012 at 7:52 am
Hi!!! After thorough reading and searching I found and selected the right answers based on the same referenced article, just to find out they were wrong?
Looks to me that the question is incorrectly configured, so can you guys who contribute make sure this does not happen?
Thanks in advance,
"El" Jerry.
February 20, 2012 at 8:04 am
I want my point !!!
Can you prepare task correctly? 🙁
February 20, 2012 at 8:12 am
EL Jerry (2/20/2012)
Hi!!! After thorough reading and searching I found and selected the right answers based on the same referenced article, just to find out they were wrong?Looks to me that the question is incorrectly configured, so can you guys who contribute make sure this does not happen?
Thanks in advance,
"El" Jerry.
I am reasonably sure the contributor thought his contribution and the answers selected as correct were correct.
I believe it is the responsibility of some one at REDGATE to execute the submitted QOD and approve or disapprove its being published. I have had that happen to a couple of my submittals. Now just who that person(s) is or are is not know to myself.
I do know that Steve Jones will review these comments and the correct/incorrect answers and will "make things right/award points" if he deems it appropriate.
February 20, 2012 at 10:00 am
Apologies. The wrong item checked. 1,2,3,5 are correct.
Points awarded back
February 20, 2012 at 10:05 am
I was surprised to see 100% right (297 correct, 1 incorrect). So I figured there must have been an issue with the question and that points were awarded back. Glad to see that I picked the correct answers anyway after Steve edited the question and awarded points back.
February 20, 2012 at 10:22 am
Thanks for the question.
http://brittcluff.blogspot.com/
February 20, 2012 at 10:53 am
February 20, 2012 at 12:28 pm
I have never seen the term Grace Hash Join before and I have been doing this for a long time. Is it named for Grace 'The Great' Hopper per chance?
February 21, 2012 at 12:37 am
Viewing 15 posts - 16 through 30 (of 32 total)
You must be logged in to reply to this topic. Login to reply