Mid-80s novella about interstellar colony ship with a caretaker/troubleshooter awakened from suspended animation?
Looking for a (short?) story about a cryo ship looking for habitable planets
SQL Coalesce in WHERE clause I'm trying to implement optional parameters in a stored procedure that I have but I am running into a problem. Here's a simplified query to illustrate the issue:  SET ANSI_NULLS OFF  DECLARE @MiddleName VARCHAR(20); SET @MiddleName = NULL;  SELECT * FROM [Customer] WHERE [LastName] = 'Torres' AND [MiddleName] = COALESCE(@MiddleName, [MiddleName])   When I run this query I need to get one row back because one Torres has NULL in the [MiddleName] column. But the query returns zero rows. Using IFNULL() produces the same result. From researching COALESCE, I was under the impression that NULL would be returned if all expressions are NULL. As I am not a SQL expert I assume that I am missing something, but what is it.....  Thanks in advance for any help. How can I execute a file without giving myself execute permissions (with chmod u+x) for it?   If I try and tick the 'Allow executing file as program' checkmark, the checkmark is immediately removed. Eisenstein Criterion with a twist As opposed to the generic polynomial form for utilizing the Eisenstein Criterion ($a_nx^n+a_{n-1}x^{n-1}+\dots+a_0\in\mathbb{Z}[x]$ is irreducible in $\mathbb{Q}$) how do we prove that if $p$ is a prime, $x^{p-1}+x^{p-2}+\dots+x+1$ is irreducible over $\mathbb{Q}$? Possible Duplicate:          I have tried using \text{\~{}} to draw a tilde in math mode. However, this only produces a superscript tilde.  I have looked around at many pages such as this one:   and surprisingly, I can't find where to draw a tilde in math mode (not under or above a character - just a single tilde character). If I just use ~, then nothing appears. Get the cartesian product of a series of lists? How can I get the Cartesian product (every possible combination of values) from a group of lists?  Input:   somelists = [    [1, 2, 3],    ['a', 'b'],    [4, 5] ]   Desired output:  [(1, 'a', 4), (1, 'a', 5), (1, 'b', 4), (1, 'b', 5), (2, 'a', 4), (2, 'a', 5) ...] How many RSA keys before a collision? What do 'real', 'user' and 'sys' mean in the output of time(1)? $ time foo real        0m0.003s user        0m0.000s sys         0m0.004s $   What do 'real', 'user' and 'sys' mean in the output of time?  Which one is meaningful when benchmarking my app? MiKTeX and Perl scripts (and one Python script) Ligatures in figures and pdftex I've gone into the Nether and seemed to have lost my portal out of it, I also can't die in lava or by mobs attacking me, I'm appear to be invincible and can't die.  This is Single Player by the way.  Why is this happening? I have something like that  how do I convert this to a YouTube playlist? Detect when browser receives file download Comparing mixed-effects and fixed-effects models (testing significance of random effects) Given three variables, y and x, which are positive continuous, and z, which is categorical, I have two candidate models given by:  fit.me &lt;- lmer( y ~ 1 + x + ( 1 + x | factor(z) ) )   and  fit.fe &lt;- lm( y ~ 1 + x )   I hope to compare these models to determine which model is more appropriate. It seems to me that in some sense fit.fe is nested within fit.me. Typically, when this general scenario holds, a chi-squared test can be performed. In R, we can perform this test with the following command,  anova(fit.fe,fit.me)   When both models contain random-effects (generated by lmer from the lme4 package), the anova() command works fine. Owing to boundary parameters, it is normally advisable to test the resulting Chi-Square statistic via simulation, nonetheless, we can still use the statistic in the simulation procedure.  When both models contain only fixed-effects, this approach---and, the associated anova() command---work fine.  However, when one model contains random effects and the reduced model contains only fixed-effects, as in the above scenario, the anova() command doesn't work.  More specifically, I get the following error:   &gt; anova(fit.fe, fit.me)  Error: $ operator not defined for this S4 class   Is there anything wrong with using the Chi-Square approach from above (with simulation)? Or is this simply a problem of anova() not knowing how to deal with linear models generated by different functions?  In other words, would it be appropriate to manually generate the Chi-Square statistic derived from the models? If so, what are the appropriate degrees of freedom for comparing these models? By my reckoning:  $$ F = \frac{\left((SSE_{reduced}-SSE_{full})/(p-k)\right)}{\left((SSE_{full})/(n-p-1)\right)} \sim F_{p-k,n-p-1} $$  We are estimating two parameters in the fixed effects model (slope and intercept) and two more parameters (variance parameters for the random slope and random intercept) in the mixed-effects model. Typically, the intercept parameter isn't counted in the degrees of freedom computation, so that implies that $k=1$ and $p=k+2=3$; having said that I'm not sure if the variance parameters for the random-effects parameters should be included in the degrees of freedom computation; the variance estimates for fixed-effect parameters are not considered, but I believe that to be because the parameter estimates for fixed effects are assumed to be unknown constants whilst they are considered to be unknowable random variables for mixed effects. I would appreciate some assistance on this issue.  Finally, does anybody have a more appropriate (R-based) solution to comparing these models? I made a simple FM transmitter following  and it worked! Now I need some help to understand how.  My coil is made of 1 mm copper wire has 6 turns and 8 mm wire diameter. According to this online calculator:  this means that: L = 3.9e-7 H  I did not have any 5 pF trim capacitor so I used a 3 pF capacitor instead.  Am I correct in assuming that the frequency this will transmit on can be found by looking at the L1 C2 as a LC oscillator and using the frequency formulae:  fR = 1/(2*pi*sqrt(LC))  ?  If so I should get fR = 147 MHz. Which is strange since I received the signal on 91.5 MHz on my radio.  In a LC circuit I understand that the signal decays exponentially over time. That is hopefully not happening here. Why? Because of C4 maybe?  Also what is the purpose of C1?  If I want to increase the range of this FM transmitter somewhat can I do this by simply replacing R2 with a 470 Ohm resistor?  Are there free simulator programs that let me see the resulting spectrum at the antenna? Where does the question mark go — inside or outside the parentheses? I know that when brackets enclose part of a sentence, the full stop goes outside.     I tripped over this morning. I was distracted by a plane (which turned out to be Superman).   If it's a full sentence, the full stop goes inside.     I tripped over. (I was distracted by a plane that turned out to be Superman.)   What happens when there's a question mark and only part of the sentence is a question?     I tripped over this morning. I was distracted by a plane (or was it Superman?)      (or was it Superman?).      (or was it Superman)?   What happens to the full stop that belongs to the rest of the sentence, and why? 8.4 - Use entity browser in a module block from in same way as I would in a custom block I am having trouble adding an image picker to a block form defined in a custom module.  If I create a custom block type I can define an image field as entity_reference and in the block's form view tell it to use entity_browser and media_entity_browser.  This provides me with an picker with which I can select my image:    I am trying to recreate this in a block provided by my custom module, without much success  // /src/Plugin/Block/MyCustomBlock.php  function blockForm($form, FormStateInterface $form_state)  {     ...      $form['image'] = [       '#type' =&gt; 'entity_browser',       '#entity_browser' =&gt; 'media_entity_browser',       '#title' =&gt; $this-&gt;t('Image'),       '#default_value' =&gt; $this-&gt;configuration['image'] ?? null,       '#weight' =&gt; '0',     ];      ... }   This gives me the following.  Note the lack of the bounding box, title and option to edit remove items:     Exporting the configuration files for the working form view gets me this:  // core.entity_form_display.block_content.lead_block.default.yml      ...  field_image:     weight: 1     settings:       entity_browser: media_entity_browser       field_widget_display: rendered_entity       field_widget_edit: true       field_widget_remove: true       selection_mode: selection_append       field_widget_display_settings:         view_mode: default       open: false     third_party_settings: {  }     type: entity_browser_entity_reference     region: content   ...   But if I try and use 'type' =&gt; 'entity_browser_entity_reference' in my blockForm function the field disappears altogether.  Looking into various core files I can see that entity_browser is a @FormElement and entity_browser_entity_reference is a @FieldWidget but I don't really understand the difference.  As you might guess I am fairly new to Drupal and I feel like I am missing something fundamental.  I (think I) understand that custom block types are actually nodes internally and that they are subject to different rules to blocks which I define in my custom modules, but I don't fully grasp what the differences here are.  Is is it possible to use the entity browser in my custom module block form in the same way as it is used in the form which I build through the admin's custom block type builder?  Thank you. Why does water take a "wet" path? Allow me to explain what I mean... ((I am asking this question in the physics section in hopes of finding a "physics" argument))  I shall make it clear what I mean by demonstrating an experiment...  Hold your hand upright with your index finger pointing up towards the sky. Now drop about 2-3 drops of water right on top of your finger. Water drop should (theoretically) stay there. Now tilt your hand ever so slightly towards one side. The water drop rolls down your finger down your wrist leaving a trail towards the tilted side right?  Now's here comes my question. Now if you bring your finger and the hand to the initial upright state and place another water drop on the same finger. Now we see that the water drop takes the same trail! Why does it happen?  My argument: The water trail which was previously left off reduced the friction in that path by filling the gaps between the molecules. Hence the new drop tends to slide more on that path and hence ends up travelling in it.  ((This "effect" is also observed when tear drops keep rolling down in the same path. But that could just be because that path is the steepest.)) Iridescence In Cycles? Is it possible to create an  shader in Cycles? Specifically for something like , , , etc.. What are point releases in LTS versions? My machine is currently running Windows 7. I have 2 partitions: OS (C:) and DATA (D:). I intend to do a native Ubuntu 14.04 install. Assuming I format my Windows OS partition, will I have full access to my D partition in Ubuntu ?