t-sql defect when selecting an non-existent column from a temp table
SQL Delete clears the table instead of erroring
How to securely delete files stored on a SSD? fsck error on boot: /dev/sda6: UNEXPECTED INCONSISTENCY; RUN fsck MANUALLY What is a NullReferenceException, and how do I fix it? Why light moves sideways? Greatings!  I'm trying to understand special relativity and have one question bugging me.  In almost every book or video about the subject there is a thought experiment with moving light clock. I hope I need not elaborate on the sutup and the outcome of the experiment.  So the question is this: When a light source on the MOVING light clock emits a photon of light the path of the photon is triangular.   How this can be?   I thought since light speed is constant in every reference frame the movment of the "emmiter" can't affect the movment of the light so light should shoot right up (from the point of stationary observer) and thus move backward and up from the point of moving observer.  So you see my logic is: light speed is invariant => you can't make it move UP &amp; FORWARD only UP. i.e. you can't change it's direction once it's emited in UP direction. Why the hell light moves sideways then?  And I'm puzzeled. There is flaw in the logic but I don't see it.  Thanks for help. Explicitly finding the sum of $\arctan(1/(n^2+n+1))$ If I have flagged a post, show me a "flags" link in my profile This week I've read two news stories about two different camera lenses that can magnify things that are very far away.  The first is the , which is a point-and-shoot camera that costs $600, has an 83x optical superzoom lens ("the same field of view as a 2,000mm lens on a full-frame camera"), and lets you see the craters of the moon.  The second is the , which weighs 36 pounds, costs $180,000, and can take portraits of people a half mile away.  A non-photographer might ask, "Why would somebody spend their life savings on a gigantic telescope of a lens when you could take far away pictures with a handheld camera for 1/300th the price?"  Well, I am basically a non-photographer, and I would like to ask that question. What does the big one give you that the little one doesn't provide? I understand that small changes in lenses can make a big difference in size and price, but this seems to be of a different scale entirely.   What is going on with the optics of the lenses that makes the small one able to be so small and the big one have to be so...big?   I'm trying to get a basic intuition for what makes lenses different, and I realize I don't understand enough about how lenses work to even know how to compare these apples and watermelons. Kate forces itself to be the default application for HTML Problems when adding a fillable PDF form if the page is rotated Where Android apps store data? I know that like is a preposition but why not using it as conjunction?  Examples:        It's as if I'm walking on air   It's like I'm walking on air      What is the difference? I get      every few minutes on Kubuntu (KDE), and the panels disappear.  It restarts itself automatically, so it's not a real problem, just an annoyance, but it is a big annoyance.  I've tried sudo apt install --reinstall plasmashell plasma-desktop, but that made no difference.  When I try a backtrace from the error message, it says it's unable to produce a useful backtrace. I can't read beta sites' chat logos! Here, you try:  If it weren't for the text shadow, it might as well be entirely invisible...  The cause is a CSS rule lurking in the transcripts for beta sites only:  #transcript-logo {   background: none repeat scroll 0 0 #273A5D; }   The problem is the #273A5D - a bluish colour not dissimilar to that used for the site name in the beta theme. Disabling that rule yields the much more manageable  I'll admit it is a little hard to read the "beta" in that shot. But if you had to choose which part was readable, wouldn't you choose the bit that tells you the name of the site?  Edit: It happens when actually in a chat room too! How can I derive effect sizes in lme4 and describe the magnitude of fixed effects? Testing for coefficients significance in Lasso logistic regression [A similar question was asked  with no answers] I have fit a logistic regression model with L1 regularization (Lasso logistic regression) and I would like to test the fitted coefficients for significance and get their p-values. I know Wald's tests (for instance) are an option to test the significance of individual coefficients in full regression without regularization, but with Lasso I think further problems arise which do not allow to apply the usual Wald formulas. For instance, the variance estimates neded for the test do not follow the usual expressions. The original Lasso paper:  suggests a bootstrap-based procedure to estimate the coefficients variance, which (again, I think) may be needed for the tests (section 2.5, last paragraph of page 272 and beginning of 273):  One approach is via the bootstrap: either $t$ can be fixed or we may optimize over $t$ for each bootstrap sample. Fixing $t$ is analogous to selecting the best subset (of features) and then using the least squares standard error for that subset  What I understand is: fit a Lasso regression repeatedly to the whole dataset until we find the optimal value for the regularization parameter (this is not part of the bootstrap), and then use only the features selected by the Lasso to fit OLS regressions to subsamples of the data and apply the usual formulas to compute the variances from each of those regressions. (And then what should I do with all those variances of each coefficient to get the final variance estimate of each coefficient?) Furthermore, is it correct to use the usual significance tests (for instance Wald's test which makes use of the estimated betas and variances) with the Lasso estimates of the coefficients and the bootstrap-estimated variances? I am fairly sure it is not, but any help (use a different test, use a more straightforward approach, whaterever...) is more than welcome. According to the answers  I suspect inference and p-values just cannot be obtained. In my case, p-values are an external requirement (although the use of L1 regularization was my choice). Thanks a lot EDIT What if I fit an OLS logistic regression using only the variables selected by a previous run of the Lasso logistic regression? Apparently (see ),  There's no need to run the model again after doing cross-validation (you just get the coefficients from the output of cv.glmnet), and in fact if you fit the new logistic regression model without penalisation then you're defeating the purpose of using lasso  But what if I do this with the sole purpose of being able to compute p-values while keeping the number of variables low? Is it a very dirty approach? :-) In JavaScript:  encodeURIComponent("©√") == "%C2%A9%E2%88%9A"   Is there an equivalent for C# applications? For escaping HTML characters I used:  txtOut.Text = Regex.Replace(txtIn.Text, @"[\u0080-\uFFFF]",     m =&gt; @"&amp;#" + ((int)m.Value[0]).ToString() + ";");   But I'm not sure how to convert the match to the correct hexadecimal format that JS uses. For example this code:  txtOut.Text = Regex.Replace(txtIn.Text, @"[\u0080-\uFFFF]",     m =&gt; @"%" + String.Format("{0:x}", ((int)m.Value[0])));   Returns "%a9%221a" for "©√" instead of "%C2%A9%E2%88%9A". It looks like I need to split the string up into bytes or something.  Edit: This is for a windows app, the only items available in System.Web are: AspNetHostingPermission, AspNetHostingPermissionAttribute, and AspNetHostingPermissionLevel. How do I check if an element is hidden in jQuery? Is it possible to toggle the visibility of an element, using the functions .hide(), .show() or .toggle()?  How would you test if an element is visible or hidden? Continuous v. per-chapter/section numbering of figures, tables, and other document elements Some document elements (e.g., figures in the book class) are numbered per chapter (figure 1.1, 1.2, 2.1, ...). How can I achieve continuous numbering (figure 1, 2, 3, ...)?  And vice versa: Some document elements (e.g., figures in the article class) are numbered continuously. How can I achieve per-section numbering?  \documentclass{book}% for "vice versa" variant, replace `book` with `article`  \begin{document}  \chapter{foo}% for "vice versa" variant, replace `\chapter` with `\section`  \begin{figure} \centering \rule{1cm}{1cm}% placeholder for graphic \caption{A figure} \end{figure}  \end{document}   Bonus question: Is it possible to adjust the numbering of the sectioning headings themselves? Can I, e.g., switch from per-chapter to continuous numbering of sections in the book class? Where can I find historical data on flights, specifically Delta international flights?  I need to find out about cancellations, diversions and any other flight data pertaining on particular route at a given time.  This source has to be official and stand up to legal scrutiny. I'm wondering if there's any log which stores information about a particular program such as when the program has started and closed manually on Windows such as MS Word, or Chrome. Any ideas?