Sacrifice help With MTG
What happens if 2 separate abilities require you to sacrifice a creature?
Do images need a border around them? Similar to this question  and an fellow up on this one    What was the official reason by Canonical to axed the project when it was love by some many of their users and innovative? Storage order vs Result order This is a spin-off question from .   says this on the subject of storage order (clustered index) and the output order     A lot of people believe that a clustered index guarantees a sort order on output. But that's not what it does; it guarantees a storage order on disk.   See, for example, .   I've read the blog post by Hugo Kornelis and understands that an index doesn't guarantee that the sql server reads the records in a specific order. Yet I have a hard time accepting that I can't assume this for my scenario?  CREATE TABLE [dbo].[SensorValues](   [DeviceId] [int] NOT NULL,   [SensorId] [int] NOT NULL,   [SensorValue] [int] NOT NULL,   [Date] [int] NOT NULL, CONSTRAINT [PK_SensorValues] PRIMARY KEY CLUSTERED  (   [DeviceId] ASC,   [SensorId] ASC,   [Date] DESC ) WITH (     FILLFACTOR=75,     DATA_COMPRESSION = PAGE,     PAD_INDEX = OFF,     STATISTICS_NORECOMPUTE = OFF,     SORT_IN_TEMPDB = OFF,     IGNORE_DUP_KEY = OFF,     ONLINE = OFF,     ALLOW_ROW_LOCKS = ON,     ALLOW_PAGE_LOCKS = ON)   ON [MyPartitioningScheme]([Date])   My original query was this:  SELECT TOP 1 SensorValue   FROM SensorValues   WHERE SensorId = 53     AND DeviceId = 3819     AND Date &lt; 1339225010   ORDER BY Date DESC   But I suggest that I could as well use this one (read below for my explanation):  SELECT TOP 1 SensorValue   FROM SensorValues   WHERE SensorId = 53     AND DeviceId = 3819     AND Date &lt; 1339225010   As you can see, my table rows are small (16bytes) and I've got only one index, a clustered. In my scenario, the table consists of 100.000.000 records at this moment (and this will most likely increase tenfold).  When the database server queries this table it has two ways of finding my rows, either it seeks the primary key and thereby reading and returning my values in desc. order of Date, or it has to do a full table scan. My conclusion is that a full table scan on all those records will be way too slow and the database server will therefore always seek the table via its primary key and thereby returning the values sorted by Date DESC Positrons versus holes as positive charge carriers : [The Dirac sea is a theoretical model of the vacuum as an infinite sea of particles with negative energy. It was first postulated by the British physicist Paul Dirac in 1930 to explain the anomalous negative-energy quantum states predicted by the Dirac equation for relativistic electrons. The positron, the antimatter counterpart of the electron, was originally conceived of as a hole in the Dirac sea, well before its experimental discovery in 1932.]  and:  [Dirac's idea is completely correct in the context of solid state physics, where the valence band in a solid can be regarded as a "sea" of electrons. Holes in this sea indeed occur, and are extremely important for understanding the effects of semiconductors, though they are never referred to as "positrons". Unlike in particle physics, there is an underlying positive charge — the charge of the ionic lattice — that cancels out the electric charge of the sea.]  It always confused me to think of holes as positive charge carriers in semi-conductors as not being real: real electrons move from one lattice-position to another lattice-position, which effectively looks like a positive hole in the lattice that is moving in the other direction, but in reality a real electron moves, the hole is kind of an "illusion".  On the other hand the positrons are always introduced as real hard-core particles.   The quotes from the Wikipedia article make me unsure: how should I look upon these phenomena?   Edit: holes in a Dirac sea give rise to real pos. entities in one case and to unreal pos. entities in another - how can we distinguish, is it a matter of formalism? Is it possible to get the progress of an XMLHttpRequest (bytes uploaded, bytes downloaded)?   This would be useful to show a progress bar when the user is uploading a large file. The standard API doesn't seem to support it, but maybe there's some non-standard extension in any of the browsers out there? It seems like a pretty obvious feature to have after all, since the client knows how many bytes were uploaded/downloaded.  note: I'm aware of the "poll the server for progress" alternative (it's what I'm doing right now). the main problem with this (other than the complicated server-side code) is that typically, while uploading a big file, the user's connection is completely hosed, because most ISPs offer poor upstream. So making extra requests is not as responsive as I'd hoped. I was hoping there'd be a way (maybe non-standard) to get this information, which the browser has at all times. I've been thinking about switching to Ubuntu full time, but there are still some programs left behind that I haven't found any equivalent to yet. Does anyone know of a music player similar to Foobar2000 (I've read it doesn't handle well in WINE)? PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given An irreducible polynomial in a subfield of $\mathbb{C}$ has no multiple roots in $\mathbb{C}$ Can we implement a dead time on answers for high reputation user Summary: High reputation users on SO come swooping in the second a simple question is posted, and get the first answer in before I've even opened my Python interpreter to test my idea out.  This actually is a problem because it prevents use lower users who aren't as good  at programming from getting any answers in.  This makes it very hard to build up reputation.  Thus, I propose a short dead time for high reputation users where their answers do not appear.  The Problem: This isn't just reputation.  By answering questions and having discussions with OP, we all get better at our language.  Teaching is one of the best ways of learning, and a more well versed population is absolutely good for SO.  (If anyone wants to argue that, go home)  While its nice to have folks who can quickly answer nearly all questions in a jiffy, its a little frustrating for those of use who simply aren't as fast, but still want to contribute.  The result is that many people do not answer questions because they feel like they just can't get an edge in.  SO should aim to incentivize as many answers by as many users as possible.  The most answers from the most users is the most beneficial situation for the site and the community. Once we accept this idea, it is clear that something needs to be done to address the issue at hand    The Solution: Luckily, this is an easy problem to solve; we use a dead time.  High reputation users can post answers whenever they like, but they won't appear until after the dead time is completed.  The trick is balance, a dead time which is too long will harm the OP as the question will remain unanswered, however, a dead time which is too short won't actually fix the problem.  There definitely needs to be a discussion about what "high reputation" means and what dead time to use, but it should be independent of whether y'all agree that this is a problem.  So, what do you think?  EDIT: Wow, -18, I leave for lunch for 30 minutes and this is what happens!  I guess y'all think this is a bad idea, but let me try to clarify a few things on which I was unclear earlier.  This is not about reputation.  This is not about getting the first answer just for the sake of getting to say "in before..."  This is about learning.  By getting a shot at answering questions before the high reputation users, people learn. Think of it as doing an example problem in class before the teacher does it. You get a chance to try it yourself, test your knowledge, and if you fail, then the teacher is right behind you to show the correct solution.  This is what I'm trying to accomplish. However, seeing the solution, and then trying to answer the question, is not very helpful. This is how I view the status quo.    In response to Mr. Pieters' answer and comments: You're absolutely right, this is not about quantity, its about quality.  The fastest answer isn't always the best.  But asking the high reputation users to take a step back for a few minutes is a means of getting there.    Hopefully this clears things up a bit. I've just been downvoted. How should I react? Writing basic systemd service files Why is a deductive closure an intersection of maximally consistent sets? Full Question: Show that if $\Delta(\Gamma)$ is the deductive closure of a consistent $\Gamma$ then $\Delta(\Gamma)$ is the intersection of all maximal consistent sets of formulas $\Lambda$ with $\Gamma \subseteq \Lambda$.  I'm really stuck with this question, I honestly don't know how to even start. Can someone please provide some assistance? I'm considering buying a solid state drive for my Unibody White MacBook 2010. The trouble is, I have no idea what to look for. What kind of connector am I looking for? (SATA?) What size? I'm told to get the kind that Apple uses so that I don't void my AppleCare warranty. What model/brand(s) would that be? Why is ${x^{\frac{1}{2}}}$ the same as $\sqrt x $? Why is ${x^{\frac{1}{2}}}$ the same as $\sqrt x $?   I'm currently studying indices/exponents, and this is a law that I was told to accept without much proof or explanation, could someone explain the reasoning behind this.  Thank you. How do I post code in chat? I would like to be able to post code in chat. I know that I can post inline snippets of code by using backticks, but I don't know how to post blocks of code, with the entire chat message formatted as code, and indentation respected. I am aware of . After reading the comments, I found out that I could format in "fixed width", but I can't see a "fixed width" button anywhere. What should I do? Similar matrices and minimal polynomial Solve for $f(x)$ if $f(f(x))=6x-f(x)$ The problems that appear in difficult math competitions such as the IMO or the Putnam exam are usually very difficult and require some ingenuity to solve. They also usually don't look like they can be solved by simply knowing more advanced theory and the such.  How do people typically come up with these problems? Do they arise naturally from advanced mathematics (the somewhat infamous 'grasshopper problem' from the 2009 IMO comes to mind - to my not exactly knowledgeable mind this problem looks like it popped out of basically nowhere)? What is the perspective that mathematicians take when seemingly "inventing" these problems with no theoretical motivation to them whatsoever? Disable password request from suspend - 18.04 Find this integral $$\operatorname I=\int\limits_{0}^{1}\dfrac{\arcsin{\sqrt{x}}}{x^4-2x^3+2x^2-x+1}\operatorname d\!x$$  My try: let $$f(x)=x^4-2x^3+2x^2-x+1$$ I found  $$f(1-x)=(1-x)^4-2(1-x)^3+2(1-x)^2-x+1=x^4-2x^3+2x^2-x+1=f(x)$$ so $$I=\int_{0}^{1}\dfrac{\arcsin{\sqrt{(1-x)}}}{x^4-2x^3+2x^2-x+1}dx$$ so $$2I=\int_{0}^{1}\dfrac{\arcsin{\sqrt{x}}+\arcsin{\sqrt{(1-x)}}}{x^4-2x^3+2x^2-x+1}dx$$ then I can't,Thank you very much