I'am aware of the "Why is the Flash not unstoppable" question but it does not answer the question for the 2014 TV-show.  Here we see the following very often:  Flash arrives and stops and talks to his opponents, often giving them time to shoot at him or invoke environmental effects that harm him. Perhaps in the first season we could argue that he is overconfident and unexperienced, but later in the show this argument does not hold, I think.  He has to "distract" them somehow with some clever trick because he can't get near them (Why? With his speed he can be behind them, disarm them and/or knock them down before they can even "fire" once at him.)  When they are "distracted" he does exactly that. In a split second he just disarms them or knocks them down.  Yes. If an opponent creates conditions that harm or hinder Flash BEFORE he arrives, it makes sense. If the opponent has super fast reflexes (like Flash himself) so he can shoot and hit him even when speeded, it makes sense. If the opponent is invulnerable and the flash when trying to knock him out hurts himself it makes sense. If the flash is surprised by the opponent and not in speed mode, it makes sense.  But we often see opponents that shoot on him with some weapons or abilities and while they don't seem to have super fast reflexes and moving, Flash isn't able to get near them and just disarm them or knock them out.  This especially is obvious in some encounters with Captain Cold. It should be no problem for Barry to disarm him and get his gun in the moment he arrives before Captain Could could even think of firing at him (later he has a dead man switch at his could gun that could in some situations prevent this).  Another example is his encounter with Dr. Light. He has to move so fast that he creates several images of him where Dr. Light fires on. Then he is able to attack her from behind and knock her down. There shouldn't be any problem doing this without the false images.  On other occasions he has no problem even with warned opponents. When he is blackmailed to let his two opponents beat him to death (otherwise several bombs will kill 100 children) his team succeeds to disarm all the bombs. The villains (who in the past were a match for him even without the other) notice that (and even say "Oh oh") and in the next moment one is bound and the other nearly beaten to death.  So is it just very very bad writing or is there any theory why Flash has problems to handle such opponents without difficulties?
I've recently gotten into The Flash TV show, and so I've been reading about his powers. What I don't understand is why his typical rogues pose a threat - it seems like there should be very little limit to his powers.  He can go back in time, so if he loses a battle or the bad guys do something, he can go back and preempt it. In the new 52, he can all but predict the immediate future, so he can see bad things that are going to happen and stop them. He can phase matter through matter, or let matter pass through him. This means he is all but immune to weapons fire.  I haven't read enough of the old comics so I don't the know challenges he's had. For a guy who can't be attacked, can time-travel and can race around the globe several times in a minute, I can't imagine there is much that could pose a threat.
How to pivot rows into columns MySQL Been looking to pivot rows (progress_check) into columns check 1, check 2 etc... No sum or totals required, just to display the results hopefully... Can anyone help, Thanks Ad Difficulty in creating macro '\newcommand' for the beginning and end of frames in Beamer How to make a circle with grid on the outside ring I made something like this:    I did this with the Ellipse Tool and the Line Tool.  Now the circle is accurate, but the lines inside are very inaccurate. Is there another tool that does the same thing but with a lot more accuracy? plotting 3d points: z-axis is squashed I am not asking for a solution to speed it up, i simply want to know how long it should take!  I would also like a way to speed it up but not something technical, im new to Blender! MSO Review Queue Privileges are Misleading I used to be able to go to Accounts and Import → Add another email address you own and add an email account that's only a forwarding address. That is, it's not a mailbox and I don't have SMTP access to it.  Gmail would send me a confirmation email to that address, I'd confirm it's mine, and done. Now it only gives me the option to add SMTP credentials.  Did they stop supporting the previous method? Is there any other way I can get that option back? Is there a way to force Google Chrome to remember passwords for sites that have autocomplete turned off? Clarification: I am a programmer, but ideally, I'd like a method that I could help regular users implement, too. Fantasy/scifi combo - band of travelers who must get from "sphere" or domain to domain - each geographic area is ruled by a magician - it turns out later these are people who are unwittingly tapping into the computer grid they all live on to alter their own reality? In PHP, how do you change the key of an array element? I have an associative array in the form key =&gt; value where key is a numerical value, however it is not a sequential numerical value. The key is actually an ID number and the value is a count. This is fine for most instances, however I want a function that gets the human-readable name of the array and uses that for the key, without changing the value.  I didn't see a function that does this, but I'm assuming I need to provide the old key and new key (both of which I have) and transform the array. Is there an efficient way of doing this? Next badge select dialog broken The "Select your next badge" dialog box is not displaying correctly. It looks like this:    Freehand circles, as requested:    It seems to be an issue with box-sizing, because when it's content-box, it looks fine. I think the width and height rules for .popup-badges .all-badge-progress .badge-progress should be increased a little, for example:  .popup-badges .all-badge-progress .badge-progress {   width: 214px;   height: 96px; }   Tested on the latest Chrome and Firefox on Linux Mint. Prove that the Gaussian Integer's ring is a Euclidean domain Are you allowed to stack Divine Smite and Eldritch Smite on the same attack? Are Mersenne prime exponents always odd? I have been researching  so I can write a program that finds them. A Mersenne prime looks like $2^n-1$. When calculating them, I have noticed that the $n$ value always appears to be odd. Is there confirmation or proof of this being true? Max length for HTML How to restrict the maximum number of characters that can be entered into an HTML &lt;textarea&gt;? I'm looking for a cross-browser solution. How to make \left, \right pairs of delimiter work over multiple lines? I have a very long equation that must be separated into two lines, and it has several pairs of nesting \left \right delimiters. Unfortunately, it seems that they need to be on the same line in order for them to work.  Also I'm using the align environment because I need the aligning functionality. Is there a way to have the size of delimiters automatically adjusted over multiple lines? Why is vote time missing in the SE data dump and SEDE? Is there a particular reason why vote times are omitted in the data dump?  IMO this could be a very useful data-set. Is this one of the steps that was done to anonymize the data, or does it simply not exist? This would be a very good addition to future dumps to help build time-based relationships, which are currently very rigid and full of assumptions. How to vote on friends / colleagues ' questions (or answers) I have a scenario where I have multiple threads adding to a queue and multiple threads reading from the same queue. If the queue reaches a specific size all threads that are filling the queue will be blocked on add until an item is removed from the queue.  The solution below is what I am using right now and my question is: How can this be improved?  Is there an object that already enables this behavior in the BCL that I should be using?  internal class BlockingCollection&lt;T&gt; : CollectionBase, IEnumerable {     //todo: might be worth changing this into a proper QUEUE      private AutoResetEvent _FullEvent = new AutoResetEvent(false);      internal T this[int i]     {         get { return (T) List[i]; }     }      private int _MaxSize;     internal int MaxSize     {         get { return _MaxSize; }         set         {             _MaxSize = value;             checkSize();         }     }      internal BlockingCollection(int maxSize)     {         MaxSize = maxSize;     }      internal void Add(T item)     {         Trace.WriteLine(string.Format("BlockingCollection add waiting: {0}", Thread.CurrentThread.ManagedThreadId));          _FullEvent.WaitOne();          List.Add(item);          Trace.WriteLine(string.Format("BlockingCollection item added: {0}", Thread.CurrentThread.ManagedThreadId));          checkSize();     }      internal void Remove(T item)     {         lock (List)         {             List.Remove(item);         }          Trace.WriteLine(string.Format("BlockingCollection item removed: {0}", Thread.CurrentThread.ManagedThreadId));     }      protected override void OnRemoveComplete(int index, object value)     {         checkSize();         base.OnRemoveComplete(index, value);     }      internal new IEnumerator GetEnumerator()     {         return List.GetEnumerator();     }      private void checkSize()     {         if (Count &lt; MaxSize)         {             Trace.WriteLine(string.Format("BlockingCollection FullEvent set: {0}", Thread.CurrentThread.ManagedThreadId));             _FullEvent.Set();         }         else         {             Trace.WriteLine(string.Format("BlockingCollection FullEvent reset: {0}", Thread.CurrentThread.ManagedThreadId));             _FullEvent.Reset();         }     } } After reading a couple of answers and comments on some SQL questions here, and also hearing that a friend of mine works at a place which has a policy which bans them, I'm wondering if there's anything wrong with using backticks around field names in MySQL.  That is:  SELECT `id`, `name`, `anotherfield` ... -- vs -- SELECT id, name, anotherfield ...