SQL statement sequential execution for multiple statments
MS SQL Server: Do multiple queries in a batch ever execute in parallel and if so what happens when the second query is dependent on the first?
Fix Accessibility of the sites on the leagues (and other pull downs that share the same code path) please The  site picker seems to be ordered on-site statistics instead of alphabetically:  This makes it very hard to find Photography, Physics, and Philosophy (for example) since they are nowhere near each other in the list. I’m open to a better solution, but as it stands, this feels a little too user-hostile to assume everyone is only interested in the first 3 to 5 top visible hits in the ordered list.  Scanning pages of unorganized contents is not optimal Keyboard input should filter and not just jump around  It also breaks accessibility when someone wishes to access the list from a keyboard (or a slower input control) as opposed to a mouse and visually. TinyMCE disable escaping Italic citation reference for author name using natbib Evaluating a PDF to find an unkown constant Evaluate the PDF to find K  $1 = \int_0^{\infty} \frac{k}{(1+x)^4}$  using u substitution I got:  $u=1+x$ and $du= dx$  $\int_0^{\infty} \frac{k}{u^4} \to \frac{k}{\frac{-1}{3} u^3}$   Since $u^4 du = \frac{u^{-4+1}}{-4+1}=$ $\frac{u^{-3}}{-3}$  which evaluating gives:  $1=\frac{k}{\frac{-1}{3(1+x)^3}} \vert_0^{\infty} \to \frac{-3k}{(1+x)^3} \vert_0^{\infty} = 0 -3k$   and $k= \frac{-1}{3}$  somehow though they came up with $\frac{-k}{3} \frac{1}{(1+x)^3}$ after integrating $\int_0^{\infty} \frac{k}{(1+x)^3}$   Was my approach correct to use substitution? Where does my work go wrong? PHP variable variables I want to store courseworks marks of n courseworks into n variables, such as cw1 and cw2 etc. Using variable variables how can I come with cw1, cw2 etc.   How can I dynamically create variables? Is there a way to see what were the Candidate Execution Plans generated by the Query Optimizer? The Query Optimizer creates more than one possible execution plan. How can I see all the plans generated before the executed one was chosen?   :     The Query Optimizer must analyze the possible plans and choose the one   with the lowest estimated cost.   Please, notice that I'm not talking about , I'm talking about candidate execution plans, the ones that were generated but not selected to be executed.  According to Benjamin Nevarez's article :     The generation of candidate execution plans is performed inside the   Query Optimizer using transformation rules, and the use of heuristics   limits the number of choices considered in order to keep the   optimization time reasonable. Candidate plans are stored in memory   during the optimization, in a component called the Memo.   Would it be possible to visualize the candidate plans rendered the way we can ? In books the equation for length contraction is derived by supposing that the velocity of the spacecraft is the same for both observers. So the question is that, is the velocity really the same for both observers? Whereas there must be some trouble in the velocities noted by observers. I mean: If the observer on the spacecraft measures the velocity of the spacecraft to be $v$ then is it possible for the other observer to measure the same velocity from the Earth? jQuery animate backgroundColor I am trying to animate a change in backgroundColor using jQuery on mouseover.  I have checked some example and I seem to have it right, it works with other properties like fontSize, but with backgroundColor I get and "Invalid Property" js error. The element I am working with is a div.  $(".usercontent").mouseover(function() {     $(this).animate({ backgroundColor: "olive" }, "slow"); });   Any ideas? How can you sync Blender configs between multiple machines? Multi-OS Portable TeX system Order of the Rubik's cube group Show that an integer of the form $8k + 7$ cannot be written as the sum of three squares. I have figured out a (long, and tedious) way to do it. But I was wondering if there is some sort of direct correlation or another path that I completely missed.  My attempt at the program was as follows:   A number of the form, $8k + 7 = 7 (mod 8)$. That is, we are looking for integers a, b, c such that $a^2 + b^2 + c^2 = 7 (mod 8)$.   LONG and TEDIOUS way: $$(8k)^2 = 0 (mod 8)$$ $$(8k+1)^2 = 1 (mod 8)$$ $$(8k+2)^2 = 4 (mod 8)$$ $$(8k+3)^2 = 1 (mod 8)$$ $$(8k+4)^2 = 0 (mod 8)$$ $$(8k+5)^2 = 1 (mod 8)$$ $$(8k+6)^2 = 4 (mod 8)$$ $$(8k+7)^2 = 1 (mod 8)$$  That is, using three of these modulo there is no way to arrive at  $$a^2 + b^2 + c^2 = 7 (mod 8)$$ Edelstein Theorem Let $(M,d)$ be a compact metric space and $d(f(x),f(y)) &lt; d(x,y) $ for all $ x\neq y$ Prove that if $f$ is a continuous fuction then there is a unique $x_0 \in M $ such that $f(x_0)=x_0$ I know that since $g(x) = d((f(x),f(y))$ is continuous then a continuous function in a compact space reaches its maximum and minimum. Then by proving that the minimum of $g(x)$ = 0 can I conclude that $x_0$ is a fixed point? how to reset a lost admin password? How to change value of ArrayList element in java This is a follow-up question to , and is somehow related to   However, my question does not concern the reviews I receive for the papers I submit, but concerns the reviews I write for papers I have been assigned. Since the whole process is done under confidentiality, it is not clear who owns the copyright on a review I wrote, and what does the review include.   For instance, let us assume that X is member of a PC of a conference Y, and assigns to me a review of a paper Z, written by A and B (assuming it's not a double-blind). Can I publish on my blog: "Here is my review for Y, asked by X, on the paper Z, written by A and B"?   I think that there are two points here:    Is it legal? (for instance, publishing the camera-ready version of a paper might be illegal due to the copyright transfer, would it be also the care here?).  Is it ethical? (who should I ask in order to do so? X? Y? A and B? everybody?).    EDIT: There is been several comments/answer wondering why I would like to publish a review I wrote. To give a bit of background of this question, I believe that the current reviewing system, created when the academic community was small and there was no Internet (i.e. no easy access to information), might not be the best, although clearly working. This is for me a very interesting debate, but somehow out of the scope the Q&amp;A format of Academia SE, which is why I tried to focus on my question on whether it was possible to do so, not if it was the best thing to do in the current system (and just to be clear, I don't plan to do it, but I just like to know what are my options). Anyway, thanks for the answers bringing a different light on this debate.   EDIT 2: After seeing the update in Jeff's answer, I just realised that I didn't make it explicit that I was talking about reviews after the reviewing process. Jeff says that it's ok if the paper is accepted, and although I clearly understand the argument of why I shouldn't publish a review of a rejected paper, the question still holds: by publishing a review of a rejected paper, I publish the information that these authors submitted this paper to this conf/journal, which is supposed to be confidential between the authors and the editors. Would I break any rule by doing so? show that Cov(X+ Y, X-Y)= Var(X) - Var(Y) Check if a class is derived from a generic class I have a generic class in my project with derived classes.  public class GenericClass&lt;T&gt; : GenericInterface&lt;T&gt; { }  public class Test : GenericClass&lt;SomeType&gt; { }   Is there any way to find out if a Type object is derived from GenericClass?  t.IsSubclassOf(typeof(GenericClass&lt;&gt;))   does not work. What does ** (double star/asterisk) and * (star/asterisk) do for parameters? Serializing anonymous delegates in C# I am trying to determine what issues could be caused by using the following serialization surrogate to enable serialization of anonymous functions/delegate/lambdas.   // see http://msdn.microsoft.com/msdnmag/issues/02/09/net/#S3 class NonSerializableSurrogate : ISerializationSurrogate {     public void GetObjectData(object obj, SerializationInfo info, StreamingContext context)     {         foreach (FieldInfo f in obj.GetType().GetFields(BindingFlags.Instance | BindingFlags.Public | BindingFlags.NonPublic))             info.AddValue(f.Name, f.GetValue(obj));     }      public object SetObjectData(object obj, SerializationInfo info, StreamingContext context,                                 ISurrogateSelector selector)     {         foreach (FieldInfo f in obj.GetType().GetFields(BindingFlags.Instance | BindingFlags.Public | BindingFlags.NonPublic))             f.SetValue(obj, info.GetValue(f.Name, f.FieldType));         return obj;     } }     Listing 1 adapted from   The main issue I can think of that might be a problem is that the anonymous class is an internal compiler detail and it's structure is not guaranteed to remain constant between revisions to the .NET Framework. I'm fairly certain this is the case based on my research into the similar problem with iterators.  Background  I am investigating the serialization of anonymous functions. I was expecting this not to work, but found it did for some cases. As long as the lambda did *not&amp; force the compiler to generate an anonymous class everything works fine.   A SerializationException is thrown if the compiler requires a generated class to implement the anonymous function. This is because the compiler generated class is not marked as serializable.  Example  namespace Example {     [Serializable]     class Other     {         public int Value;     }      [Serializable]     class Program     {         static void Main(string[] args)         {             MemoryStream m = new MemoryStream();             BinaryFormatter f = new BinaryFormatter();              // Example 1             Func&lt;int&gt; succeeds = () =&gt; 5;             f.Serialize(m, succeeds);              // Example 2             Other o = new Other();             Func&lt;int&gt; fails = () =&gt; o.Value;             f.Serialize(m, fails); // throws SerializationException - Type 'Example.Program+&lt;&gt;c__DisplayClass3' in Assembly 'Example, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' is not marked as serializable.         }     }   Listing 2  This is similar to the issue of trying to serialize iterators and I had found the following code in a previous search (see ) Using the code from Listing 1 and an ISurrogateSelector I was able to successfully serialize and deserialize the second failing example.  Objective  I have a system that is exposed via a web service. The system has a complex but small state (many objects, not a lot of properties per object). The state is saved in the ASP.NET Cache, but is also serialized to a BLOB in SQL in case of cache expiration. Some objects need to execute arbitrary "events" upon reaching some condition. Hence they have properties accepting Action/Func objects. Contrived example:      class Command     {         public Command(Action action, Func&lt;bool&gt; condition);     }   Somewhere else      void DoSomethingWithThing(Thing thing)     {         state = Store.GetCurrentState();          Command cmd = new Command(() =&gt; thing.Foo(), () =&gt; thing.IsReady())         state.Add(cmd);          Store.Save(state);     }