If I add a foreign key constraint with the following command:  ALTER TABLE [abc]  WITH CHECK ADD  CONSTRAINT [fk_some_col]    FOREIGN KEY([some_col_id]) REFERENCES [xyz] ([some_col_id])   Is there any reason or advantage to follow it with this line?  ALTER TABLE [abc] CHECK CONSTRAINT [fk_some_col]
ALTER TABLE [dbo].[REMINDER_EMAIL]  WITH CHECK ADD  CONSTRAINT    [FK__REMINDER_EMAIL__FACILITY_ID] FOREIGN KEY ( [FACILITY_ID] )   REFERENCES [dbo].[FACILITY] ( [FACILITY_ID] )  ALTER TABLE [dbo].[REMINDER_EMAIL] CHECK CONSTRAINT [FK__REMINDER_EMAIL__FACILITY_ID]
Looking for old book, SF, artificial world, different zones for different species that visitors "inhabit" I read this book at least ten years ago.  Any help identifying it would be appreciated.  Characters are teleported to an artificial world where each take over the mind of a different species.  I remember a moving sentient plant, a faun-like character, and a wasp-like character.  The planet is subdivided into different zones designed for each species.  One of the characters had long sharp fingernails with poison in them.  Thanks for any help, steve Maximum Likelihood Estimation (MLE) in layman terms Could anyone explain to me in detail about maximum likelihood estimation (MLE) in layman's terms? I would like to know the underlying concept before going into mathematical derivation or equation. Azimuth and Distance, NumericalDigitize, Numerical Vertex Edit, XY tools and other plugins are not on QGIS Plugin Manager version 2.0.1 Will these plugins no longer be available in QGIS 2.0.1? I'm having some troubles understanding the solution (going from step $2$ to step $3$) of this linear congruence equation. Here's the problem with the solution:   Solve the congruence $2x + 11 \equiv 7 \pmod 3$.   First, we reduce all the coefficients $\pmod 3$:  $$2x + 2 \equiv 1 \pmod 3. \tag{1}$$  Next, we add $1$ to both sides, using the fact that $2 + 1 \equiv 0 \pmod 3$:  $$2x \equiv 2 \pmod 3. \tag{2}$$  Finally, we multiply both sides by $2$, using the fact that $2 · 2 = 4 \equiv 1 \pmod 3$:  $$x \equiv 1 \pmod 3. \tag{3}$$  That is, any number in the set $\{\ldots, −5, −2, 1, 4, \ldots\}$ will solve the original congruence.    Like I said my problem is the step between $(2)$ and $(3)$. If I multiply both sides of $(2)$ by $2$ I get:  $$4x \equiv 4 \pmod 3.$$  Now, I understand that $4$ is congruent to $1 \pmod 3$ so the RHS "simplifies" to $1 \pmod 3$ but I don't understand why the LHS "simplifies" to $x$. Can someone help me with this? Setting width/height as percentage minus pixels ‘ld: warning: directory not found for option’ Short story with competitors complaining to government about a new very popular synthetic food find a $\int_{x}^{g(x)} f(t)\,dt = 1$ Let $f : [0, 2] → \mathbb{R}$ be a continuous, positive function and  $$\int_{0}^1 f(x)\,dx = \int_{1}^2 f(x)\,dx= 1$$ For each $x \in [0, 1]$, prove that there exists a unique function $g(x) \in [1, 2]$ such that $$\int_{x}^{g(x)} f(t)\,dt = 1$$ and $g \in C^1$. Well, I think in $g(x) = x +1$, but I'm not sure. Any hint is appreciated.  Thank you. Determine the probability densities for coefficients of equation Is it possible to make an ASP.NET MVC route based on a subdomain? Is it possible to have an ASP.NET MVC route that uses subdomain information to determine its route?  For example:   user1.domain.com goes to one place user2.domain.com goes to another?   Or, can I make it so both of these go to the same controller/action with a username parameter? I stumbled upon a question given like:  Let $m$ and $n$ be two integers such that $m \geq n \geq 1$.   Count the number of functions $$f: \{1, 2, · · · , n\} \to \{1, 2, · · · , m\}$$ of the following two types:  (a) strictly increasing; i.e., whenever $x &lt; y, f(x) &lt; f(y)$, and  (b) non-decreasing; i.e., whenever $x &lt; y, f(x) \leq f(y)$.  I tried in the following way.  For (a). We can say $f(n)&gt;f(n-1)$ AND $f(n)&gt;f(n-2) \ldots f(n)&gt;f(1)$ (total $n-1$ elements)  Similarly for $f(n-1)&gt;f(n-2), f(n-1)&gt;f(n-3) \ldots f(n-1)&gt;f(1)$ (total $n-2$ elements)...  and $f(2)&gt;1$  Like this $$(n-1) + (n-2) + \ldots + (1) = \frac{n(n-1)}{2}$$  Is this correct?  For (b). Since there's equality, it will be $$n + (n-1) + ... (1) = \frac{n(n+1)}{2}$$  Is my approach correct? Any help is appreciated. Thanks in advance. How can I make sharp geometric 3d models look more realistic? I'm making a scene in Blender with manufactured mechanical and electrical objects - cylinders, metal objects and so forth. I want to make these look real, be fully present with a sense of mass and substance.  3DCG has a tendency to make everything very sharply geometric, often looking mathematical and artificial. In other scenes, some organic curves, normal maps or particle systems would help make object look real. Like for example, making a simple plastic dog model look more believable, one can add more vertices for better definition, add texture layer, add fur etc.  My scene shows clean resistors, wires, metal strips and such, all sharply geometric. It's tricky to find ways to make the result less mathematical and more substantial, realistic and interesting to the eye.  What are some effective ways to add realism to these objects? Get OS-level system information I'm currently building a Java app that could end up being run on many different platforms, but primarily variants of Solaris, Linux and Windows.  Has anyone been able to successfully extract information such as the current disk space used, CPU utilisation and memory used in the underlying OS? What about just what the Java app itself is consuming?  Preferrably I'd like to get this information without using JNI. Compare dates in query from IMPORTRANGE and cell for a few days I'm stuck at comparing two dates.  In a big table with dates as columns and products as rows, we want to display the amount of sales per day per product.  What the following query does:   Import our sales via IMPORTRANGE query the specific sales for a given day and product ID return 0 if there is an error (e.g. not found) count the result   This is a working query with the date 2018-03-26 hard coded:  =COUNTA(IFERROR(query(IMPORTRANGE("1OHR0nr_w3oFNNxtMxRwv65xncCBRpK-vV3vvqmHGFPo"; "Sales March!A:K"); "select Col6 where Col6 = '"&amp;$A95&amp;"' and todate(Col11) = date '2018-03-26'"; 0)))  It shows how many sales a specific product has on the specified date.  Now I want the date from a cell in the sheet:  =COUNTA(IFERROR(query(IMPORTRANGE("1OHR0nr_w3oFNNxtMxRwv65xncCBRpK-vV3vvqmHGFPo"; "Sales March!A:K"); "select Col6 where Col6 = '"&amp;$A95&amp;"' and todate(Col11) = date '"&amp;$AR3&amp;"'"; 0)))  But this doesn't work. I tried A LOT of things for the past 3 days but I have no idea if I did that wrong (I'm a beginner) so I'm turning to you. What might be wrong with the date comparison in this section?  "select Col6 where Col6 = '"&amp;$A95&amp;"' and todate(Col11) = date '"&amp;$AR3&amp;"'"  You can see it  in Column AR Row 95 but I can't give edit rights. What happens when a photon hits a mirror? When a photon of light hits a mirror does the exact same photon of light bounce back or is it absorbed then one with the same properties emitted? If the same one is bounced back does it's velocity take all values on $[-c,c]$ or does it just jump from $c$ to $-c$ when it hits the mirror?  Or, is the phenomenon of a mirror better explained using a wave analogy? If so, what is this explanation? In many C/C++ macros I'm seeing the code of the macro wrapped in what seems like a meaningless do while loop.  Here are examples.  #define FOO(X) do { f(X); g(X); } while (0) #define FOO(X) if (1) { f(X); g(X); } else   I can't see what the do while is doing.  Why not just write this without it?  #define FOO(X) f(X); g(X) What is the difference between 'can', 'could', 'may' and 'might'? I'm a native English speaker and I've been doing some research into English grammar for a programme I'm working on. However, on looking into modal verbs, I've only just come to appreciate how subtle and complicated they are.  What is the difference between these sentences? What possible different response might one have to each?        I can go to the cinema tonight.   I could go to the cinema tonight.   I may go to the cinema tonight.   I might go to the cinema tonight.      Granted, the first of these looks more like a statement of ability or possibility than the three that follow. But in what ways does it differ from the others, since all suggest ability and possibility? And crucially, what distinguishes the other three.  Perhaps it's a matter of tone, of context, of the speaker... The question may appear quite simple but I haven't found a satisfactory answer elsewhere.    looked quite useful in that it covered levels of confidence and certainty but it was talking about the potential state of something rather than the possibility for the person who is speaking. Are there any differences in that sense?   looked at these verbs used in question form (e.g., differences between 'Can I...?' and 'May I...?') but I'm not so interested in that for now.  Any thoughts appreciated. How to get a dock on multiple monitors I have two monitors, but only one dock, which is somewhat annoying, so my question is, how do I get multiple docks? (One on each screen) I downloaded the iso file for XUbuntu. I created a live usb using Pen Drive Linux. I turned on my computer, booted to the XUbuntu installation screen, and selected "check disk for defects".  A minute later, it says that it found one defect. How do I figure out what this defect is? Why is Lightroom not rendering what I see in every other JPG viewer?