Close Vote options no longer include option for "must include code" and "must show minimal understanding"
Improving "demonstrate a minimal understanding" close reason
How do you select the fastest mirror from the command line? I want to update my sources.list file with the fastest server from the command line in a fresh Ubuntu Server install. I know this is trivially easy with the GUI, but there doesn't seem to be a simple way to do it from from the command line? How to count the node a user has created in a View? I tried to reproduce the results from the  unfortunately the video link is broken. And I might have overlooked some related settings.  The spot light is barley visible on the ground.    Increasing the Density of the Volume Scatter Node darkens the sky texture but leads to some light cone from the car's headlight. (only 10 samples in preview).    Which settings do I need to change or should I try a different approach?  Integrator settings are default and spotlight settings were copied from the example found in the docs.  Related:    (pre 2.7)  (BI only) How did the Death Star move? In the Star Wars saga, one of the most iconic weapons of the Empire was the Death Star: a self sustained weapons platform the size of a moon, with the capacity to destroy a planet. in A New Hope, we see the first Death Star in close proximity to the planet Alderaan, holding the planet hostage as the Empire tries to deduce the location of the Rebel Alliance's headquarters. In Return of the Jedi, we see the second Death Star in "dry dock" over the forest moon of Endor as it is being constructed.  My question is: How did the Death Star move? I imagine a spherical space station the size of a moon would be utterly massive, requiring a massive amount of thrust to move it. If it was constructed in low orbit of an inhabited planet/moon, the gravitational field would be immense, consisting of the planet/moon's gravity, and the Death Star's own considerable gravity. Breaking that gravitational field would be a massive task, yet we see no thrusters or engines on either Death Star. Were they hidden, stored under the station's surface while not in use? Was the station towed by another vessel? Do I have to clear customs when transit via the US on my way to / coming from somewehere else? I shall arrive at Washington Dulles Airport (IAD) by Emirates flight to catch a united airlines flight to Detroit after 3.5 hours. What steps shall I have to go through? Is the connection time enough? I have US F1 visa. Every once in a while after updating MiKTeX, the installation gets into an inconsistent state. This might be a problem with the packages (an example is described in ), but sometimes packages are split or renamed. The cases I remember are when  and when miktex-etex-base-2,9 was renamed to miktex-etex-base-2.9 (if I recall correctly; I am sure it was either that or something very similar). In each case the MiKTeX Update process suggested to remove the "old" packages but it didn't give the user any hints about him having to manually add the respective replacement packages back in the package manager to get one's MiKTeX installation back into a usable state.  What are best practices for keeping MiKTeX up to date? Note that I'm not asking about installing new packages or fonts in general; there are other questions covering this area.   In which order should one execute the Update process and the Synchronization of the repository? , it is recommended to check the MiKTeX homepage before updating. What else should one do? When and in which order (and why) should one execute the "Refresh FNDB" and "Update Formats" processes within the MiKTeX Options menu? What else can happen? Other advice? Why is the well ordering principle counter-intuitive? I read  that while 'The Axiom of Choice agrees with the intuition of most mathematicians; the Well Ordering Principle is contrary to the intuition of most mathematicians'. I don't understand why this is so. According to Wikipedia, 'the well-ordering principle states that every non-empty set of positive integers contains a least element'. This is quite a straightforward definition. Is it the way you derive the equivalence of the Axiom of Choice and well ordering principle that makes it counter-intuitive or the definition of the least element? Although Ubuntu 16.04 release notes mention that:  The default VIM package has been built against python3 instead of python2.  Yet after I installed vim with the following command:  sudo apt-get install vim   And checked:  vim --version   It showed:  -python -python3   Is it a bug? How do I get vim with Python support? Python does not find packages installed without Anaconda Ubuntu 20.04 Network Performance Extremely Slow I just upgraded from Ubuntu 18.04 to 20.04 on one of the  machines, and the network performance is abhorrent. Internet speed is very fast from a google speed test (>300Mb/s for both upload and download).     However, whenever I try to browse a website or even run sudo apt update the connection will often time out. My internet is very fast on all other devices and I really don't know how to debug this problem.  sudo lshw -class network -short &amp;&amp; nmcli device status    shows  H/W path           Device           Class          Description ============================================================== /0/100/1c.6/0      wlp2s0           network        Wi-Fi 6 AX200 /3                 br-96f5b790e29e  network        Ethernet interface /4                 br-15e76fb81c05  network        Ethernet interface /5                 docker0          network        Ethernet interface  DEVICE           TYPE      STATE         CONNECTION       wlp2s0           wifi      connected     CSA HQ           br-15e76fb81c05  bridge    connected     br-15e76fb81c05  br-96f5b790e29e  bridge    connected     br-96f5b790e29e  docker0          bridge    connected     docker0          p2p-dev-wlp2s0   wifi-p2p  disconnected  --               lo               loopback  unmanaged     --               gpd0             tun       unmanaged     --                Solution:  It seems like this is a pretty common problem, and one without a definitive cause. For me, it was because Ubuntu resets the TLP configuration, and the power management went back to "on". I disabled Wi-Fi power management directly by editing:  sudo nano /etc/NetworkManager/conf.d/default-wifi-powersave-on.conf   Then changed the value from 3 to 2, saved changes and rebooted.  I actually got this solution from Reddit and this worked for my case specifically but it seems like it could be caused by a bunch of other things. Read all the proposed solutions below! I have a simple query:  select * from countries   with the following results:  country_name ------------ Albania Andorra Antigua .....   I would like to return the results in one row, so like this:  Albania, Andorra, Antigua, ...   Of course, I can write a PL/SQL function to do the job (I already did in Oracle 10g), but is there a nicer, preferably non-Oracle-specific solution (or may be a built-in function) for this task?  I would generally use it to avoid multiple rows in a sub-query, so if a person has more then one citizenship, I do not want her/him to be a duplicate in the list.  My question is based on the similar question on .  UPDATE: My function looks like this:  CREATE OR REPLACE FUNCTION APPEND_FIELD (sqlstr in varchar2, sep in varchar2 ) return varchar2 is ret varchar2(4000) := ''; TYPE cur_typ IS REF CURSOR; rec cur_typ; field varchar2(4000); begin      OPEN rec FOR sqlstr;      LOOP          FETCH rec INTO field;          EXIT WHEN rec%NOTFOUND;          ret := ret || field || sep;      END LOOP;      if length(ret) = 0 then           RETURN '';      else           RETURN substr(ret,1,length(ret)-length(sep));      end if; end; Do I need a Kuwait transit visa as an Indian national? I am an Indian national and passport holder, traveling from New Delhi to Frankfurt (via Kuwait) and back with Kuwait Airways. I see no Terminal change for the onward and return journeys. I have no plans to leave the airport due to short layovers.  Do I need a Kuwait transit visa? Determining whether two $k$-chromatic graphs are isomorphic (respecting vertex coloration) Laptop (Asus x555u) screen turns off as soon as you remove the power cord Let $x = (a, b), y = (c, d) \in \mathbb{Z}^2$. What is the condition on $a, b, c, d$ so that ${x, y}$ is a basis?   My answer: $ad\neq bc$ and $gcd(a, c) = gcd(b, d) = 1$.  The first condition ensures that they aren't the same vector; the second ensures that we can actually "get" all of the integer values/lattice points.  Is this correct?  Thanks. Why intra-word ** highlighting is broken to protect programming_underscore_usage? Should I capitalize the word "that" in a title? Since the version of the word "that" might matter to the correct answer, I'll provide the actual title in question:  Title:  Existing Solutions that Didn't Work  If someone could explain the why of the answer, I would be appreciative.  EDIT:  It has been suggested that this is a duplicate, and that may be, in a sense.  However, the after reading the suggested prior question, I'm no closer to my answer.  I think it may have to do with my use of the word "that."  Perhaps it is incorrect?  Using these definitions of the word "that:" I'm having trouble figuring out which definition of that matches my title.  Am I even using it correctly?  Perhaps I should use which instead:  Possible Title:  Existing Solutions which Didn't Work  If my original usage is incorrect, and I should use which, then the answer is simple since which is always a pronoun or adjective, and those are both capitalized in a title.  However, I'm having difficulty understanding which part of speech that is in my original title. How do I get a consistent byte representation of strings in C# without manually specifying an encoding? How do I convert a string to a byte[] in .NET (C#) without manually specifying a specific encoding?  I'm going to encrypt the string. I can encrypt it without converting, but I'd still like to know why encoding comes to play here.  Also, why should encoding even be taken into consideration? Can't I simply get what bytes the string has been stored in? Why is there a dependency on character encodings? On approving an edit, I just get this pop up since morning. At first I thought there might be some internet connection issue, but this is now the 3rd to 4th time I got the same error; also, the review is accepted because on refresh I can see my name with approved text beside, but it still throws this error.    I am on a Windows 7 machine, running Firefox 24 (Icognito/Private Mode)    Also, this happens only when edit(1) is written on an question/answer, I don't go to review queue and approve, these reviews were directly loaded from the notification beneath the question/answer.  Martijn Pieters reproduced the problem from the review queue three times; each time the improve option was picked, accepting the suggested edit but editing the post some more. The network console shows that posting to https://stackoverflow.com/review/task-reviewed fails, the server responds with a 404 error:  Request headers: POST /review/task-reviewed HTTP/1.1 Host: stackoverflow.com Connection: keep-alive Content-Length: 137 Accept: application/json, text/javascript, */*; q=0.01 Origin: http://stackoverflow.com X-Requested-With: XMLHttpRequest User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36 Content-Type: application/x-www-form-urlencoded DNT: 1 Referer: https://stackoverflow.com/review/suggested-edits/3575396 Accept-Encoding: gzip,deflate,sdch Accept-Language: en,en-US;q=0.8,nl;q=0.6,nb;q=0.4,no;q=0.2,de;q=0.2,fr;q=0.2 Cookie: &lt;redacted&gt;  POST data: taskTypeId=1&amp;reviewTaskId=3575396&amp;taskResultTypeId=5&amp;fkey=f8791a329b445b658876f4d3afe7961e&amp;postCommentId=null&amp;taskResultSubtypeFlags=null  Response headers: HTTP/1.1 404 Not Found Cache-Control: private Pragma: no-cache Content-Type: application/json X-Frame-Options: SAMEORIGIN Date: Fri, 13 Dec 2013 12:04:53 GMT Content-Length: 0   On the  itself, no record is made of the accept; instead the suggested edit is recorded as approved by 3 people not including Martijn Pieters. In this case the improve review arrived too late.  In , improve again resulted in the error, but the Community account is shown rejecting the edit. I attended a business meeting in the Midwest and one of our clients took our management team and a few other business partners to dinner at an awesome Mexican restaurant. When the appetizers were served I commented that it was a wonderful presentation and that everything looked very fresh, including the avocado slices.   Speaking to the woman seated across from me I said that even though I use a good amount of lemon juice, whenever I prepare avocados they still turned dark pretty quickly. This happens whether they are sliced, used in guacamole, etc. She responded that the secret is to use lime juice. She proceeded to tell me that she was born and raised in Central America and that it is customary there to use fresh limes or juice rather than lemon.  I have tried it and lime seems to work much better than lemon, so it would stand to reason that they are more acidic. However, I never thought there was that much difference. So, on to the questions.  Are limes more acidic than lemons? Are there any other differences in their properties that could make a difference?