Experts,  I am trying to learn more about the CONVERT_IMPLCIT and Probe Residual. Can someone explain to me why the following test script cause  Probe Residual?  My understanding is if both join predicate column are of the same datatype and is defined as "NOT NULL" then it should not cause any Residual  Reference and Test script    CREATE TABLE #BuildBigInt (     col1    BIGINT NOT NULL );  CREATE TABLE #ProbeBigInt (     col1    BIGINT NOT NULL ); GO  DECLARE @I INTEGER = 1;  INSERT #BuildBigInt     (col1)  VALUES      (CONVERT(BIGINT, RAND(1) * 9999999));   WHILE @I &lt; 5000 BEGIN     INSERT #BuildBigInt         (col1)     VALUES        (CONVERT(BIGINT, RAND() * 9999999));     SET @I += 1; END;    INSERT #ProbeBigInt         (col1) VALUES      (CONVERT(BIGINT, RAND(2) * 9999999));   WHILE @I &lt; 5000000 BEGIN     INSERT #ProbeBigInt         (col1)      VALUES          (CONVERT(BIGINT, RAND() * 9999999));      SET @I += 1;  END;   --test query  SELECT     COUNT_BIG(*) FROM #BuildBigInt AS bbi JOIN #ProbeBigInt AS pbi ON     pbi.col1 = bbi.col1 OPTION (MAXDOP 1);
Say, we have a query like this:  select a.*,b.* from  a join b on a.col1=b.col1 and len(a.col1)=10   Assuming the above query uses a Hash Join and has a residual, the probe key will be col1 and the residual will be len(a.col1)=10.  But while going through another example, I could see both the probe and the residual to be the same column. Below is an elaboration on what I am trying to say:  Query:  select * from T1 join T2 on T1.a = T2.a    Execution plan, with probe and residual highlighted:         Test data:    create table T1 (a int, b int, x char(200)) create table T2 (a int, b int, x char(200))  set nocount on declare @i int set @i = 0 while @i &lt; 1000   begin       insert T1 values (@i * 2, @i * 5, @i)     set @i = @i + 1   end  declare @i int set @i = 0 while @i &lt; 10000   begin     insert T2 values (@i * 3, @i * 7, @i)     set @i = @i + 1   end   Question:    How can a probe and a residual be the same column? Why can't SQL Server use the probe column only? Why does it have to use the same column as a residual to filter rows again?  References for test data:
Can you use another material as input to material nodes in cycles? Does leaning (banking) help cause turning on a bicycle? When does reflow happen in a DOM environment? What kinds of activities will trigger reflow of web page with DOM?  It seems there are different points of view. According to ,  it happens   When you add or remove a DOM node. When you apply a style dynamically (such as element.style.width="10px"). When you retrieve a measurement that must be calculated, such as accessing offsetWidth, clientHeight, or any computed CSS value (via getComputedStyle() in DOM-compliant browsers or currentStyle in IE).   However, according to , taking measurement triggers reflow only when there is already reflow action queued.  Does anybody have any more ideas? Can I run an HTTP GET directly in SQL under MySQL? I'd love to do this:  UPDATE table SET blobCol = HTTPGET(urlCol) WHERE whatever LIMIT n;   Is there code available to do this? I known this should be possible as the  include an example of adding a function that does a DNS lookup.  MySQL / windows / Preferably without having to compile stuff, but I can.  (If you haven't heard of anything like this but you would expect that you would have if it did exist, A "proly not" would be nice.)  EDIT: I known this would open a whole can-o-worms re security, however in my cases, the only access to the DB is via the mysql console app. Its is not a world accessible system. It is not a web back end. It is only a local data logging system From Geneva airport to Lausanne station On September 4, I will be arriving in Geneva by airplane at approximately 11 AM. After that, I need to go to Lausanne. I have two questions:   Do I need to buy a train ticket online, or can I buy it directly at the station without any problems? (Problems such as: the trains are always full, it's not permitted to buy a ticket etc.) Moreover, are the tickets only for a specific train or it is like "you can board any train from Geneve to Lausanne with this ticket"? How do I get from the airport to the Geneva train station (as low a budget as possible, I guess walking is not an option though), and how much does it cost?   I'd appreciate answers from people who have been there, but if you're able to find an exhaustive link from any website that's okay too. Plot showing discontinuity where it shouldn't This came up in  , but I can't see good documentation or examples that explain how the feature works. How can I limit ssh *remote* port forwarding? I need to limit which ports can be remotely 'ssh -R' forwarded by an user.  I know about permitopen option on authorized_keys, but as it says on man page it only limits local 'ssh -L' port forwarding  As discussed  a user would get the same with netcat or similar, but in this case user has no shell access  I also found  that talks about using selinux or LD_PRELOAD, but I never configured selinux before and can't find info on how to do that with LD_PRELOAD.  maybe someone have made a patch for openssh to implement that?  EDIT: I've found  so I guess it's not yet implemented What kind of node is this? PS4 Controller not connecting to PS4 and won't reset? Panasonic Eneloop BK-3MCC (4th gen) - where I can find maximum discharge current? Im looking for some official information source about maximum current for Panasonic Eneloop BK-3MCC rechargeable batteries.  All I found is , there is just 1 table (nothing about maximum discharge current), charge and discharge characteristics.  UPDATE LINK:   / edited - I fixed my mistake, I meant 6A not 8A /  There is discharge characteristic for 6000mA discharge. So... I can safely draw 6A from that AA cell? Identify the ring $\mathbb{Z}[x]/(2x)$ Consider the quotient ring $R:=\mathbb{Z}[x]/(2x)$. Could somebody help me to identify $R$ with some well-known ring?    Thank You. Can I run PC steam games on a Mac? I recently downloaded 'Blood Bowl' on Steam to my Mac, not realizing that it was not Mac-compatible. Is there any software or any way that will allow me to play it, as obviously I've already paid for it? Cheers. What does it mean by 'bringing him gasping to all fours' in Harry potter? Immediately, his insides started writhing as though he'd just swallowed live snakes -- doubled up, he wondered whether he was going to be sick -- then a burning sensation spread rapidly form his stomach to the very ends of his fingers and toes -- next, bringing him gasping to all fours, came to a horrible melting feeling, as the skin all over his body bubbled like hot wax -- and before their eyes, his hands began to grow, the fingers thickened, the knuckles were bulging like bolts -- his shoulders stretched painfully and a prickling on his forehead told him that his hair was creeping down toward his eyebrows -- his robes ripped as his chest expanded like a barrel bursting its hoops -- his feet were agony in shoes four sizes too small      Harry potter and the chamber of secrets   It is the description of the feeling of drinking Polyjuice Potion, which makes someone into a different person, from the point of view of Harry Potter turning into Gregory Goyle.  And I don't understand what 'bring him gasping to all fours' means, especially 'four'. Does four here mean number 4? Is it possible to get back your deleted Terraria character? Cardinality of order types in $\mathbb{N}$ Let be the next equivalence relation on $B= \{R \subseteq \mathbb{N}\times\mathbb{N} \ | \ R \ is \ a \ well-order \ on \  \mathbb{N}\}$ : $$"R \equiv R' \leftrightarrow \ (\mathbb{N},R) \cong (\mathbb{N},R') \ are \ well-ordering \ sets \  isomorphic" $$  Which is the cardinality of $B/\equiv$?  Firstly, we can notice that each well-ordering set is isomorphic to an ordinal $\alpha \ $such that $\alpha &lt; \aleph_{1}$, and so it is enough to count how many ordinals are isomorphic to a subset of $\mathbb{N}$. For example, if we consider $A$ the set of the even numbers and $B$ the set of odd numbers with the usual order relation, $A \oplus B$ is isomorphic to $\omega + \omega$. Another example could be: if we consider the order of $\mathbb{N}$ that we use in Sharkowski Theorem, that order is isomorphic to $ \omega^{2} + \omega$. Working with prime numbers we could build also $\omega^{n} \ \forall n \in \mathbb{N}$, and so $\omega^{\omega}$ and maybe something bigger. However, we know that each countable ordinal is isomorphic to a subset of $\mathbb{Q}$, but I bet that the same result is not true for $\mathbb{N}$ because it is "too small".  What can I do? Please explain this put option UIRefreshControl without UITableViewController How to access java-classes in the default-package? I'm working now together with others in a grails project. I have to write some Java-classes. But I need access to an searchable object created with groovy. It seems, that this object has to be placed in the default-package.   My question is: Is there a way to access this object in the default-package from a Java-class in a named package? Does encrypting my home folder make my computer more secure? Do I have to enter my password more if my home folder is encrypted? What else should I know about encrypting my home folder?