Table variable for large amount of data
What's the difference between a temp table and table variable in SQL Server?
How to send mail from the command line? How to send mail from the command line? I'm reading a lot of documentation on sed, and am still stumped on my particular use case.  I want to replace this line in a conf file with my own line:  Replace this line: #maxmemory &lt;bytes&gt; with: maxmemory 26gb  This is what I tried:  sed s/maxmemory.*bytes.*/maxmemory 26gb/ /etc/redis/redis.conf  I get the error: sed: -e expression #1, char 30: unterminated `s' command  Which stumps me because I don't know what that means. So my question is:  How can I accomplish what I want? What does that error mean? (so I can learn from it) How should we deal with duplicate answers? See a list of my top voted comments? Or another way to track progress on Pundit? Pundit  Left 10 comments with score of 5 or more   I saw a discussion question that mentioned Pundit, which that stated that , however, something like top voted comments seems to fit in with the rest of stackoverflows feature set, as well as indirectly provide a method to track progress on this badge. Should there be (or is there already) a list of my top voted comments somewhere? One can show that $\mathbb{P}^n\times \mathbb{P}^m$ is birational to $\mathbb{P}^{n+m}$ by making note of the Zariski topologies and the canonical isomorphism between affine spaces $\mathbb{A}^n\times \mathbb{A}^m\to \mathbb{A}^{n+m}$.   Question: Does it follow that there is isomorphism $\mathbb{P}^n\times \mathbb{P}^m\to \mathbb{P}^{n+m}$? If so, what is an example of such an isomorphism?   Unfortunately I am having a hard time coming up with one, and haven't seen too many examples thus far. C# How do I click a button by hitting Enter whilst textbox has focus? I'm working with a WinForm app in C#, after I type something in a textbox I want to hit the Enter key but the textbox still has focus (flashing cursor is still in textbox), how can I achieve this? pgfplots axis scaling Is it possible to define in pgfplots that y should correspond to Y cm in my plot?   I know how to do this in tkz-fct, so let me add an tkz-fct example to make more clear what I want:  \documentclass{article}  \usepackage{pgfplots} \usepackage{tkz-fct} \usetkzobj{all}  \begin{document}  \begin{tikzpicture}[scale=.5] \tkzInit[xmax=10,ystep=3,ymax=10] \tkzAxeXY \tkzGrid \tkzFct[color=red, thick,domain=0:10]{\x} \tkzFct[domain=0:10]{\x**2} \end{tikzpicture} \begin{tikzpicture}[scale=.5] \tkzInit[xmax=10,ystep=1.5,ymax=10] \tkzAxeXY \tkzGrid \tkzFct[color=red, thick,domain=0:10]{\x} \tkzFct[domain=0:10]{\x**2} \end{tikzpicture}   \end{document}     In one case 3 corresponds to 0.5 cm on the y-axis in the picture, in the other case 1.5 corresponds to 0.5 cm on the y axis. This is achieved by using the scale=0.5 option together with the ystep option.  Not that it is important for me to have grids as in the tkz-fct example. How to insert text before the first line of a file? Radius of convergence of $\sum_{n=0}^\infty n!x^{n^2}$ The question is to calculate the radius of convergence of $\sum\limits_{n=0}^\infty n!x^{n^2}$.  I dont know how to calculate R.O.C for such type of questions involving $n^2$ as power of x. How do we do this? Any help appreciated. Expected time to roll all 1 through 6 on a die What is the average number of times it would it take to roll a fair 6-sided die and get all numbers on the die?  The order in which the numbers appear does not matter.  I had this questions explained to me by a professor (not math professor), but it was not clear in the explanation.  We were given the answer $(1-(\frac56)^n)^6 = .5$ or $n = 12.152$  Can someone please explain this to me, possibly with a link to a general topic? Can't indent heredoc to match code block's indentation If there's a "First World Problems" for scripting, this would be it.   I have the following code in a script I'm updating:  if [ $diffLines -eq 1 ]; then         dateLastChanged=$(stat --format '%y' /.bbdata | awk '{print $1" "$2}' | sed 's/\.[0-9]*//g')          mailx -r "Systems and Operations &lt;sysadmin@[redacted].edu&gt;" -s "Warning Stale BB Data" jadavis6@[redacted].edu &lt;&lt;EOI         Last Change: $dateLastChanged          This is an automated warning of stale data for the UNC-G Blackboard Snapshot process. EOI  else         echo "$diffLines have changed" fi   The script sends email without issues, but the mailx command is nested within an if statement so I appear to be left with two choices:    Put EOI on a new line and break indentation patterns or Keep with indentation but use something like an echo statement to get mailx to suck up my email.   I'm open to alternatives to heredoc, but if there's a way to get around this it's my preferred syntax. Consider a set $A$ of $10$ integers, $A = \{a_1,a_2, \ldots ,a_{10}\}$. Prove that there is at least one subset of $A$ whose sum is divisible by $10$. Improve the editing flow with predefined options for "Edit Summary" The current is maximum through those segments of a circuit that offer the least resistance. But how do electrons know beforehand that which path will resist their drift the least? Allow the author to delete their own question after closure, if other rules permit it I've read through a few "I want to delete my own question" threads on  already, and haven't found any that particularly cover this case.  I asked a question recently on :    This was voted closed as a duplicate of this question:    Since the latter question was obviously an appropriate duplicate, and my question had no votes or answers whatsoever, I decided I would just delete it.  But then, I was greeted by this error:     To allow for possible reopening, you may delete in 2 days     This all happened within hardly 20 minutes of me posting the question in the first place.  I fail to understand the point of this.  Perhaps if there were some up-votes or answers to the question, it might make sense.  However, as it stands, we now have a question with:   No votes whatsoever (up or down). No answers. Only a single (and largely irrelevant) comment not made by the OP. Five 3k+ rep users agreeing it is duplicate and therefore superfluous. The OP expressly desiring the question to be deleted, implying:   The OP has probably reviewed the duplicate question, and found their answer there. The question holds no further value to the OP. The OP agrees (with the close-voters) that the question provides no added value to the community.    At this point, what good reason could there be for disallowing the OP to delete their own question?  Could the system be modified to permit this? Is it normal for a fast prime to exhibit purple fringing in middle of the image? I have just bought a Nikon 50mm f/1.8D prime lens.  I took this picture (leg of my glasses frame on a mouse, and a LED desk lamp is on top of it) : f1.8, 1/80s, ISO 200   The purple fringing is right in the middle of the picture. Does it happen very often to this lens? Set a default parameter value for a JavaScript function Close and flag links do nothing on mobile site This morning (it's about six AM here) I find that I can no longer submit close votes; the link just jumps to the beginning of the page.  I'm on iOS, using a third-party browser called Grazing, but a brief check with Mobile Safari shows the same problem there.   Here on Meta, where my score is much lower, I only get a "delete" link on my own question, and that works fine. (Oops :-))   Update: As per comments, this affects the "flag" link, too, which doesn't even scroll to the top of the page. Update 2: Latest comment suggests this affects Android, too. Update 3: This also affects desktop computers when viewing mobile (when you click "mobile" in the footer) Update 4:  mentions Windows 8, too; simply deleting platform-specific tags Logical explanation why exponentiation operation is not commutative and associative Considering Peano axioms we'll define addition, multiplication and exponentiation operations.  We can then prove that addition and multiplication operations are commutative and associative. The proof for addition operation is pretty straightforward but for for multiplication it a bit more difficult. For example, to prove associativity, we have to prove distributivity first.  Moreover, for the definition itself it is not obvious that commutativity should take place, because the definition is not symmetric.  $a \cdot 0 := 0$  $a \cdot S(b) := a \cdot b + a$  Here $S(b)$ is the "next" function from Peano axioms  This definition is not symmetric with respect to $a$ and $b$, so commutivity is not obvious.  For exponentiation operation neither commutivity nor associativity take place. And I am very curious about the logical explanation why that happens  NOTE: The explanation I am looking for is somehow similar to a Abel–Ruffini theorem which explains WHY there is no an algebraic solution for a general polynomial equation How can I animate the Restrict Visibility property of an object?