Cannot sign in because game asks for my date of birth and I cannot remember which date I had written
Is it possible to log back into a Pokemon Go account?
Optimizer not choosing index union plan Why is the following query slow?  select count(*)   from [dbo].[mt_dispatch_link]     , [dbo].[_mt_dispatch] [_mt_dispatch]  where   (mt_dispatch_link.contract_id_1 = _mt_dispatch.contract_id       and mt_dispatch_link.dispatch_id_1 = _mt_dispatch.dispatch_id)     or   (mt_dispatch_link.contract_id_2 = _mt_dispatch.contract_id       and mt_dispatch_link.dispatch_id_2 = _mt_dispatch.dispatch_id)     It takes over 10 minutes, and then I tend to stop it at that point. My question is more about how to make sense of the query plan.  Looking at the query plan I can see that the bottom clustered index scan is returning about 250000 records, but the cost is 0% and it is being put into a temporary table.  The top index scan is about 25000 records.  But the cost of 95% comes from the nested join. What conclusions should I draw from this?  The above query plan shows two index scans, does that mean it is doing 25000 + 250000 index scans, or does it mean that it is doing 25000 * 250000 index scans?  If I change the query to this (adding FORCESEEK):  select count(*)   from [dbo].[mt_dispatch_link]     , [dbo].[_mt_dispatch] [_mt_dispatch]       WITH (FORCESEEK)  where   (mt_dispatch_link.contract_id_1 = _mt_dispatch.contract_id       and mt_dispatch_link.dispatch_id_1 = _mt_dispatch.dispatch_id)     or   (mt_dispatch_link.contract_id_2 = _mt_dispatch.contract_id       and mt_dispatch_link.dispatch_id_2 = _mt_dispatch.dispatch_id)   I end up with a much better plan and the query runs instantly:    I ran update statistics on both tables. Didn't fix it unfortunately. The table design is not very good, so I think SQL Server doesn't really understand and is thus coming up with a poor query plan. Some more info about the table design at .  Why is the query optimiser not coming up with the optimum plan? Why "grand theft auto", not "grand auto theft"? There is a video game series called "Grand Theft Auto".  According to its :     The name of the series references the term used in the US for motor   vehicle theft.      [...]      Motor vehicle theft or, grand theft auto, is the criminal act of   stealing or attempting to steal a car (or any other motor vehicle).   I always wondered why this term sounds so strange.   Shouldn't it be "grand auto theft" or maybe "grand theft of auto" instead? Are there any other terms with strange words order and/or missing prepositions like this? Getting "'file' is different from the same file on the system" when I attempt to update through synaptic Is the claim that functions of independent random variables are themselves independent, true?   I have seen that result often used implicitly in some proofs, for example in the proof of independence between the sample mean and the sample variance of a normal distribution, but I have not been able to find justification for it. It seems that some authors take it as given but I am not certain that this is always the case. Can I install the free Windows 7/8 -> 10 upgrade on a new empty drive? With the new Windows 10 coming out soon as a free upgrade, I'd like to know if and how I can install the upgrade on a new HDD. I assume the files needed for Windows 10 are only for upgrading an installed copy of Windows 7 or 8 and not a standalone installer to use on an empty hard drive. Or is this assumption wrong?  I have some issues booting (an older non-working version appears in the list of OS's to choose from) and I'd like to replace my current SSD, which is too small, with a new larger capacity one, while keeping my other drives intact. The old SSD will then be removed.  If more information is needed, please let me know. Dirac's remark that inspired Feynman when formulating path integral When Feynman was trying to formulate  of quantum mechanics, he was inspired by Dirac's remark which roughly states that $e^{i\frac{S}{\hbar}}$corresponds to the transition amplitude, where $S$ is the action.   I'm wondering what was Dirac's original argument behind this statement. How do websites block selecting text and how do I unblock that? There's a website () that somehow blocks selecting text. Also it blocks Ctrl+A to select everything, there is also no “Copy” in the popup menu.  What I have tried:  Some sites use JavaScript to block selection. So I disabled all JavaScript sources in no-script addon in Firefox. I tried the same site in Google Chrome with the Script Safe addon. Made sure that everything is blocked, still can’t select text. Mousepointer remains an arrow and not a text cursor also on the whole site.  Used about:config to disable JavaScript completely in Firefox. Still no effect.  I read that some sites use DIVs with the style display:block so I used Inspect to examine the styles of the site. There is not one mention of "block" on the whole website, not in embedded CSS nor in object style=-attributes.  The text is not an image or flash or some HTML5 canvas ect. Everything is within DIV and P tags but no style was found that might block the text selection.  How can the website still block any selection of text? Not to mention why browsers support such behaviours at all. I just want to use a selected word or sentence and want to search google for it using right mouse click. It’s pretty annoying when a website does such things and forces me to type technical terms and names into google by hand. It disturbs my workflow. How and when should I tell my son that his amazing father isn't his biological father? My son is going on 5 and starting to learn a lot about how we're created. I've been with my husband for 10 years, but nearly 6 years ago I had no other choice but to move 1000 miles away and after trying the long distance thing it didn't work so we split up.   I ended up going through a rough patch and started dating an abusive jerk. After a year I was pregnant. He threatened me trying to force me to have an abortion and I refused. His grandmother was chief of police and he scared me into moving back to Florida.  Eventually, when I was 4 months along in my pregnancy my husband and I picked up right where we left off. He loved me so much and accepted our son as if he was his own and has done an amazing job at raising him.   He enrolled in college while I was pregnant, got us a house and went above and beyond to care for us both (as after giving birth I became very ill due to rare brain and spine conditions). I've always tried to do right by my son. Since day one, even while with my husband, I tried to keep the sperm donor involved. But he wanted no part of his son.  My husband stepped up when the biological father refused. The biological father would pretend that he cared, only to tell me he never cared about him anyway and was just trying to manipulate me into stopping child support (which I did anyway after the first year: I felt it wasn't right to take his money when my son had a dad who loved, supported and wanted him from the beginning).  This is a very long story so I'll try and make it not so much of a novel. The sperm donor has made it very clear he wants nothing ever to do with my son. My husband has been Dad since the moment my son entered this world. I've always planned to tell my son as early as possible. I think now, or in a few years, it won't be as hard on him compared to us telling him when he's a teen and who knows how he'd handle it.   I just don't know what to do. We have an extremely happy loving family. My son adores his dad. We never argue, we have a very happy non-dysfunctional marriage. I just feel we have a very special family. But I refuse to lie to my son. What if we wait and someone else maliciously tells him? Or if, when he's older and finds out, he spirals out of control?  I'm so confused, I just want to do the right thing and desperately need advice. Especially from others who have been through similar circumstances. We're planning on meeting with therapists and I guess child development specialists, if someone could also point me in the right direction for what type of doctor is best suited in this situation.   Also my son is very happy. He has a wonderful life and I feel as if he would do fine, knowing how much he loves his dad and just beginning to really grasp the concept of life. I don't think it would change anything for him, if that makes sense. I've been worrying over this for 5 years and really need some answers! Why does no line appear when using Interpolate Line in ArcMap? I'm using Xubuntu 14.04 64 bit. I know that question been asked a billion times, but all of them consist of editing following file:  /etc/polkit-1/localauthority/50-local.d/com.ubuntu.enable-hibernate.pkla   That file does not exist on my system. I tried com.xubuntu.enable-hibernate.pkla but doesn't exist either, locate command doesn't find it. I would like to run a script from the main ubuntu shell as a different user that has no password.  I have full sudo privileges, so I tried this:  sudo su -c "Your command right here" -s /bin/sh otheruser   Then I have to enter my password, but I am not sure if that script is now really running under that user.  How can I confirm that the script is really running under that user now? C++ pointer address issue Sum of reciprocals of numbers with certain terms omitted When writing a book and referring to a female and male aged 18–25, what term would be most appropriate? Boy and girl seem too young, whereas man and woman seem too old.  Example sentence:     A boy/man emerged from the shadows.   Edit: I think the word I am looking for is similar to 'guy' but less American and colloquial. Any thoughts? Is there a grammatical term for moving a word to the front or back of a sentence? There is a function in Arabic grammar where you may bring forward in sentence order a word - as well as deferring it.  For example: if the sentence order is Subject - Verb - Object, you can bring the object forward to be before the subject,  yielding Object - Verb - Subject or Object - Subject - Verb.  Similarly, if you have Noun Phrase - Verb Phrase, you can move the verb phrase forward so you get Verb Phrase - Noun Phrase.  This is used to add emphasis to the item brought forward. The same applies to moving the item to the end of the sentence.  Is there a grammatical term in English that represents this function or functions? Windows 8.1 missing font files after restart Some days ago I rebooted my windows 8.1 system. After the reboot all my system texts were very cryptic - showing only some strange symbols. After some investigation I discovered that my c:\windows\fonts folder was nearly empty. So I copied the font files from another windows 8.1 installation to the nearly empty folder. As soon as I had copied the files the system texts were readable again.  But after another reboot the problem occured again - the systems font folder was empty again. Does anyone know why windows deletes my font files during a restart? Set Snap Mode with PyQGIS What should be the intuition when working with compactness? I have a question that may be regarded by many as duplicate since there's a  one at MathOverflow. The point is that I think I'm not really getting the idea on compactness. I mean, in $\mathbb{R}^n$ the compact sets are those that are closed and bounded, however the guy who answered this question and had his answer accepted says that compactness is some analogue of finiteness. That's the first problem: In my intuitive view of finiteness, only boundedness would suffice to say that a certain subset of $\mathbb{R}^n$ is in some sense &quot;finite&quot;. On the other hand there's the other definition of compactness (in terms of covers) which is the one I really need to work with and I cannot see how that definition implies this intuition on finiteness. Also, I feel it's pretty strange the covers people use when they want to deal with compact sets. To prove a set is compact I know they must show that for every open cover there's a finite subcover; the problem is that I can't see intuitively how one could show this for every cover. Also when trying to disprove compactness the books I've read start presenting strange covers that I would have never thought about. I think my real problem is that I didn't yet get the intuition on compactness. So, what intuition should we have about compact sets in general and how should we really put this definition to use? Can someone provide some reference that shows how to understand the process of proving (and disproving) compactness? Can a US citizen leave and enter the US using a foreign passport? I am a dual citizen. I have both a US passport and a non-US passport. I live in the US. My US passport is currently being processed for renewal. I am unsure whether I will receive my passport in time for a trip that I have scheduled. Could I use my non-US passport to leave the US and return? I have never entered the US with my non-US passport. There is no immigration leaving the US but I still need to scan my passport for ticketing. Will the airline refuse me a ticket? I know that in this situation returning with a non-US passport can be problematic as well, but will I be able to leave at all? Note that I am traveling to a country which neither of my passports are from. Someone is offering to pay me in a sort of sugar daddy/sugar baby arrangement. They want to make online deposits to me, and they're asking me for my online banking username and password. Is that information alone enough for them to be able to take my money out of my account, or am I safe?