Group by SQL Server (show all elements in selected group by)
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
How are the file metadata stored in Windows? (I'm using Windows XP but I guess it's similar in all the recent versions of Windows.)  When you create for example a new empty text document, you'll find in its properties that it has size of 0 bytes. Zero bytes means no information. No data. But still, the file has some name, it can still carry the dates of last access, modification and creation. It carries the information whether it's hidden file or not, whether it's read-only or not...  So where are all the metadata stored? I'm new to Linux but not to app development. I come from a RealBasic on a Mac background.   I've accepted that I need to learn a new language to develop for Linux (since RB won't run on 64 bit distros and is a cloed proprietary language) but I want to make sure I pick the right one.   I've been looking at Python and was all set to go until I read that PyGTK is becoming obsolete with the introduction of GTK 3. Is this true? The Ubuntu developer website stills seems to recommend it with Glade for the UI but I want to make sure that I don't learn something that's on the way out! What is the autocorrelation for a random walk? Seems like it is really high, but this is counterintuitive to me. Can somebody please explain? I am very confused by this issue and would appreciate a detailed, insightful explanation. Thanks a lot in advance! I am getting my feet wet with Git and have the following issue:  My project source tree:  / | +--src/ +----refs/ +----... | +--vendor/ +----...   I have code (currently MEF) in my vendor branch that I will compile there and then move the references into /src/refs which is where the project picks them up from.  My issue is that I have my .gitignore set to ignore *.dll and *.pdb.  I can do a git add -f bar.dll to force the addition of the ignored file which is ok, the problem is I can not figure out to list what files exist that are ignored.  I want to list the ignored files to make sure that I don't forget to add them.  I have read the man page on git ls-files and can not make it work. It seems to me that git ls-files --exclude-standard -i should do what I want.  What am I missing? How can I do this fast?  Sure I can do this:  static bool ByteArrayCompare(byte[] a1, byte[] a2) {     if (a1.Length != a2.Length)         return false;      for (int i=0; i&lt;a1.Length; i++)         if (a1[i]!=a2[i])             return false;      return true; }   But I'm looking for either a  function or some highly optimized proven way to do this.  java.util.Arrays.equals((sbyte[])(Array)a1, (sbyte[])(Array)a2);   works nicely, but it doesn't look like that would work for x64.  Note my super-fast answer . Define additional math operators to be typeset in roman It would be nice if backticked code in question titles were rendered the same way they are in question bodies. Since there are so many questions with code in them I feel it would be a big plus. .  This would look a lot nicer in listings and on the page itself if the code strings were rendered as such.  Similar ideas discussed . Windows 98 on a modern computer? What do I need to install LED strip lighting? I've been looking to install LED strips, either RGB or white for lighting and ambiance. It wouldn't be the main lighting of the room, so no necessity for high power LEDs.  The perimeter of the room is a little less than 25 meters. Looking around in online stores, I saw that the reels come in maximum lengths of 5 meters, so I would need five of those.  What I'm not sure is how to connect the strips together.  I was looking at , or  with .  If I choose the white LEDs, what power supply, controller, and connector would you recommend to be able to daisy chain the strips?  If I choose the RGB LEDs, what kind of data repeaters would work to be able to control all the strips at once? Atomic Physics: stimulated emission I'm studying a chapter about atomic physics right now but there's thing I just don't seem to understand. When stimulated emission occurs, there's an incoming photon which stimulates the atom to go an energy level lower with the result that a new photon gets emitted.  Can someone explain the reason why the incoming photon stimulates the atom to emit a second one? To me it seemed more logic for the atom to absorb the photon and go an energy level up. There seems to be a phenomenon which I don't know about. Ackermann Function primitive recursive I am reading the wikipedia page on ackermann's function,   And I am having trouble understanding WHY ackermann's function is an example of a function which is not primitive recursive.  I understand that the ackermann function terminates, and thus is a total function. So why is it not primitive recursive? The only information that i can find on the wikipedia page is      [Ackermann's function] grows faster than any primitive recursive function and is therefore   not primitive recursive   Which isn't a good example of why it is not primitive recursive.  Could anyone explain to me how exactly ackermann's function is NOT primitive recursive please? Travelling without a visa after passport was stolen how to permanently disable ubuntu updates & hide install updates button pic included how to permanently disable ubuntu updates pop up &amp; hide or remove Install Updates button pic included see below: Can somebody please check if my proof is okay?  Prove that $||z_1|-|z_2|| \leq |z_1-z_2|$.  Attempt: This proof seems similar to the triangle inequality proof.  $$\begin{split} |z_1-z_2|^2 &amp;= (z_1-z_2) \overline{(z_1-z_2)} \\ &amp;= (z_1-z_2)(\bar z_1 - \bar z_2) \\ &amp;= z_1\bar z_1 - z_1 \bar z_2 - \bar z_1 z_2 + z_2 \bar z_2\\ &amp;=|z_1|^2 - 2Re(z_1 \bar z_2) + |z_2|^2\\ &amp; \geq |z_1|^2 -2|z_1 \bar z_2| + |z_2|^2 \\ &amp;= |z_1|^2 - 2|z_1||z_2| + |z_2|^2 \\ &amp;= (|z_1| - |z_2|)^2. \end{split}$$  Taking the square root of both sides gives $|z_1|-|z_2| \leq |z_1-z_2|$  Can I just take the norm of both sides so that $||z_1|-|z_2|| \leq ||z_1-z_2|| = |z_1-z_2|$?  Thank you. Tense change: previous actions on something that's currently true How is the /tmp directory cleaned up? Is it automatic? If so, how frequently is it cleaned up? SQL Server - Combining OUTER and INNER joins I have 3 tables and I have to inner join Table A with Table B but a left outer between Table A and Table C.   Can I combine outer and inner join in the same query? I can nest queries and attain the desired result but I am unable to do both the joins in the same query. It appears that in other SQL languages, the order of joining is important. Is this the case in SQL Server as well?    Ok, here's the scenario.  Consider 3 tables. Table A, Table F, Table D.  I will need the recordset to contain all rows in D irrespective of whether it exists in F (after it's inner joined with A). So, a outer join comes to mind. What I would need is:   First do a inner join between A and F to get a set (this may be a null set) Then do a outer join with the recordset in (1) with D Tooltip with the question's tags in the hot questions column At this time, Wubi does not work with Windows 8 default boot-loader. Thus at this point Wubi would not work on a new Windows 8 machine.      Citation fom    Question  Recently I've learned of , a way to install Ubuntu right from Windows.  Besides installing from Windows, I would like to know key differences between a regular "alongside Windows" or Dual-boot Ubuntu installation and one done with Wubi. Are there any disadvantages (for example a performance penalty) or incompatibilities I should look out for when using Wubi? Finding the variable name passed to a function Let me use the following example to explain my question: public string ExampleFunction(string Variable) {     return something; }  string WhatIsMyName = &quot;Hello World&quot;; string Hello = ExampleFunction(WhatIsMyName);  When I pass the variable WhatIsMyName to the ExampleFunction, I want to be able to get a string of the original variable's name. Perhaps something like: Variable.OriginalName.ToString()  Is there any way to do this?