Why can't SQL Server optimizer use foreign key
Hash join between master/detail tables produces too-low cardinality estimate
Quitting a job in the US on a work visa, going to Canada and re-entering on a tourist visa (ESTA waiver) I have been working in the USA on an E-3 visa and intend to return home to Australia, but I want to travel around the US before I do so. I am under the impression that after leaving my current company, I will have 10 days to leave the country.   Will I be able to go into Mexico or Canada and re-enter with an ESTA waiver as a tourist? Why wasn't Poe told about Holdo's plan? What's the difference between $(stuff) and `stuff`? How to edit a file in vi editor (arrow keys prints letters)? I am open a file in vi:  vi index.php   Here the problem is: when I press the down arrow and it prints 'B'. Why it prints 'B'? List of functions not integrable in elementary terms When teaching integration to beginning calculus students I always tell them that some integrals are "impossible" (with a bit of expansion on what that actually means).  However I must admit that the examples I give mostly come from "folklore" or guesswork.  Can anyone point me to a list (not a complete list of course!) of fairly simple elementary functions whose antiderivatives are not elementary?  I'm thinking of things like $\exp(x^2)$ which is the standard example, $\sin(\exp(-x))$ perhaps, things like this, not hugely complicated formulae. Sometimes, when I upgrade a system via do-release-upgrade, the update process fails and the script tells me to finish the process manually via dpkg --configure -a. This is a not serious problem - after manually solving the dependencies problem and the finishing upgrade process all works well.  But the do-release-upgrade script has a cleanup process after finishing the upgrade:  Remove obsolete packages?   XXX packages are going to be removed.   Continue [yN]  Details [d]y   which removes some obsolete packages from old version of system.  Seems that this process doesn't execute when the automatic upgrade fails and I finish upgrade manually, so obsolete packages from old version remain installed in the system.  How I can run the "Remove obsolete packages" process manually after finishing the upgrade by hand? In C++, what is a virtual base class? I want to know what a "virtual base class" is and what it means.  Let me show an example:  class Foo { public:     void DoSomething() { /* ... */ } };  class Bar : public virtual Foo { public:     void DoSpecific() { /* ... */ } }; Union of two vector subspaces not a subspace? My hypothesis is that $\mathbb{R \times R}$,  the set of all pairs $(r_1, r_2)$, of real numbers is uncountable. I understand that the set of all pairs of natural numbers is countable. But could someone explain why the set of all pairs of real numbers uncountable? I am having trouble proving it using diagolization I know that this machine does not work, via thermodynamics. I am asking for an analysis in terms of mechanics and magnetism.  Anyway, so here is the machine:   (source: )    The magnet (the red ball) pull the ball up the ramp, and then it drops the ball through the hole, which then rolls down, and go ups the ramp again. Thermodynamics shows that this can not work.  From a mechanics and magnetism perspective, what happens when you do this, and why can't it happen?  I have a source saying that it would work if it were frictionless and we didn't try to extract energy from it (), so in a certain sense, it is very close to possible (they didn't provide a full analysis though.)  Another Image: Let $A$ be a $m \times n$ matrix with entries from some field $F$. Define the determinant rank of $A$ to be the largest possible size of a nonzero minor, i.e. the size of the largest invertible square submatrix of $A$. It is true that the determinant rank is equal to the rank of a matrix, which we define to be the dimension of the row/column space.  It's not difficult to see that $\text{rank} \geq \text{determinant rank}$. If some submatrix of $A$ is invertible, then its columns/rows are linearly indepedent, which implies that the corresponding rows/columns of $A$ are also linearly indepedent.  Is there a nice proof for the converse? Hello I am taking a Discrete Mathematics course and having some trouble with this question about sets:  Under what conditions is $A- B = B- A$  Diagram:   Diagram:   Maybe I'm understanding incorrectly, but how can A-B and B-A be equal if they contain elements that are not in each other? Most of the time one or the other feels better, but every so often, "which" vs. "what" trips me up.   So, what's the exact difference and when should you use one or the other? Updated WiFi fix for Yoga 13 and Ubuntu 16.04? I have a Lenovo Yoga 13 and I was running 14.04 on it and I've since upgraded to 16.04. I applied the fix descibed here () with 14.04 and it worked but no longer seems to with 16.04. I know that the way Realtek drivers work was reorganized in Linux kernel 4.4 () however I don't know enough about what was changed to know if that was the problem. Has anyone else experienced this issue or know how to fix it? How to turn off magic quotes on shared hosting? I want to turn off PHP's magic quotes.  I don't have access to php.ini.  When I tried to add php_flag magic_quotes_gpc off to my .htaccess file, I get a 500 internal server error. This is what my .htaccess file looks like:  AddType x-mapp-php5 .php php_flag magic_quotes_gpc off   Then I tried to use ini_set('magic_quotes_gpc', 'O'), but that had no effect.  How do I turn magic quotes off? I'd like to know how many downloads of a given package in a PPA there have been since it was first published.  I remember there was  about it about getting these metrics on the web UI, but as far as I know, it never got implemented.  But I think the number of downloads can nevertheless be obtained via the  if I'm the owner of that PPA. Any pointers? I'm setting up an Nginx web server and and want to perform load balancing using the round robin method.  This is what I have found thus far:  upstream backend  {    server backend1.example.com;    server backend2.example.com;    server backend3.example.com; }   According to the page they says i need to add the above lines to my nginx.conf file and upload it to server to load balance.  I do not understand what it means by server backend3.example.com;.  How do I setup a backend instance? If $\,\gcd(a,b) = {\rm lcm}(a,b)\,$ then prove $a=b$ Number of automorphisms of a direct product of two cyclic $p$-groups Suppose I have $G = Z_{p^m} \times Z_{p^n}$ for $m, n$ distinct natural numbers and $p$ a prime. Is there a combinatorial way to determine the number of automorphisms of $G$? This looks like a question asked , but it isn't.  $$T(n)=\begin{cases} T (\sqrt{n}) + 1 \quad &amp; \text{ if } n&gt;1 \\  1 &amp; \text{ if }n=1\end{cases}$$  My professor gave this to me in class yesterday. This is where I'm stuck:   $$T(n) =  T(n^{1/2})+1 =  T(n^{1/4})+2 = T(n^{1/8})+3 = \dots =   T(n^{1/ 2 ^k})+k$$  Now this will continue till  $$n^{1/ 2 ^k}=1$$  How do I proceed ahead? If I take log on both sides, then RHS becomes zero. How do I solve the relation?  I don't want to use the Master theorem, I want to know where and why am I stuck.