I have 100+ sql server instances (from sql 2005 to sql 2016) installed in my environment, is there a good way to find when an instance was initially installed?   I tried to check the [master] database creation date, and found (for sql 2012 onward at least) it is always Apr 8, 2003.  The only possible date is [msdb] creation date, which I see it changing for different sql server instances. (I am not sure about this is because I am not sure whether a service patch will change the [msdb] creation date?)  Is there any other reliable way that can indicate the sql server instance creation date? I am open to use of t-sql or powershell to figure it out.  Thanks in advance.
I am interested in determining the ages of all 70+ my servers. I would like to create a growth graph showing when servers and databases were added to the environment either/both monthly or annually. I executed the following query using the SSMS multi-query feature with only partial success.  SELECT [name], create_date FROM sys.databases   It's partial success because the master and model databases return with a date of 'April 8, 2003' when I know that I created some of these servers during the past couple years.  I refresh databases from one server to another several times a week, which appears to be causing issues with the database create date.   Is there a simple method to determine the actual create date for both servers and databases?
Is my expansion of the state $| x \rangle$ correct? Set Windows process (or user) memory limit Is there any way to set a system wide memory limit a process can use in Windows XP? I have a couple of unstable apps which do work ok for most of the time but can hit a bug which results in eating whole memory in a matter of seconds (or at least I suppose that's it). This results in a hard reset as Windows becomes totally unresponsive and I lose my work.  I would like to be able to do something like the /etc/limits on Linux - setting M90, for instance (to set 90% max memory for a single user to allocate). So the system gets the remaining 10% no matter what. Daily forecasting We have three years of data for online visits at a daily level. We want to forecast the daily visits for the next 90 days. What would be the best method to capture weekday seasonality , holiday seasons, and also the drift.  Can this be successfully done in R? We are currently using R. We have considered ARIMA but it does not capture seasonality.  While converting the data to a time series in R,  what should be the "frequency"?  Should we use ARIMA with regressors? xslt processing on select attribute on apply-templates Can "Wow!" be a sentence? The question is clear. Can "Wow!" be a sentence?  Imagine a hypothetical context where I'd utter something like this:     Wow! What an amazing idea! I should think about a way to push this fix.   We see "wow" in casual speech often. It bears punctuation marks (typically an exclamation mark, denoting the rising intonation) and a capital letter &mdash; just like all "regular" sentences.  On the other hand, neither Wow! nor What an amazing idea! contain any verbs. These certainly don't have any parts of speech in the other sentence, so what are they? Are they sentences or clauses? In other words, can "Wow!" be a sentence despite its lack of [any implied] verbs, and subsequently lack of any distinguishable predicates?  Please back up your answers with references. Create a local texmf tree in MiKTeX In TeX Live there are TEXMFLOCAL for admin and TEXMFHOME for user pre-defined, but in MiKTeX there’s by default no local texmf tree installed, though it is useful, cf. . Therefore my question:  How do I create a local texmf tree in MiKTeX? Why $\gcd(qb+r,b)=\gcd(b,r)$? Given: $a = qb + r$. Then it holds that $\gcd(a,b)=\gcd(b,r)$. That doesn't sound logical to me. Why is this so?    Addendum by LePressentiment on 11/29/2013: (in the interest of  and averting a duplicate)  What's the intuition behind this result? I only recognise the proof and examples solely due to algebraic properties and formal definitions; I'd like to apprehend the result naturally. How to split by commas that are not within parentheses? I see all of these software that claim that they can recover messages deleted from your iPhone. Do they actually work?  For example, if I received 2 text messages from my friend and I immediately deleted them. Is it possible to recover them? As  shows, we nearly always use the possessive form of personal pronouns for friend of mine/his/ours/etc.  But when it comes to actual names, we prefer  without the possessive apostrophe. That preference is even more marked with, say, . Not that I think the usage itself is particularly American - it's much the same with .  Personally, I find friend of him grates. In general I've no strong feelings either way as to whether it's friend of Peter or friend of Peter's (though I deplore the possessive in ), but in line with many others, I really don't like the possessive in relation to things like countries.  Why is this?   Edit: Noting an apparent "progression" (pronoun -> person -> nation) marked by reduction in use of the possessive, I checked at a finer "granularity". NGram shows that although it does occur,  virtually "flatlines" against friend of mine. But the bias reduces through of you, of us, and by the time I get to  it's much less extreme. There seems to be something "egocentric" about the double possessive.  Presumably when babies learn to speak, they soon notice that possessive pronouns, possessive apostrophes, and the word "of", all do the same job. Parents would correct a child who says "of mine's", but probably wouldn't even notice the same "redundancy" in "of Peter's". Younger speakers are unlikely to even be talking about something "of America's". Perhaps as we mature we tend to discard the "double possessive" for the more "distant" things that only adults are likely talk about, but we keep it for "closer" people because that's how we spoke when we were younger.  EDIT2 I note that I'm a great fan of him is vanishingly rare compared to ...fan of his, but with ...fan (of John) the double possessive occurs far less often than ...friend (of John's). Usage seems to be affected by the noun before "of" as well as the one after it. This is getting complicated... How well will WCF scale to a large number of client users? Does anyone have any experience with how well web services build with Microsoft's WCF will scale to a large number of users?  The level I'm thinking of is in the region of 1000+ client users connecting to a collection of WCF services providing the business logic for our application, and these talking to a database - similar to a traditional 3-tier architecture.   Are there any particular gotchas that have slowed down performance, or any design lessons learnt that have enabled this level of scalability? Parse DateTime with time zone of form PST/CEST/UTC/etc Keeping track of where everyone is is hard.  I could be out in the wasteland while Dogmeat will let me know he found something. That's great, but then it's a chore trying to find him a lot of times. Sometimes, he'll even run ahead and attack enemies and I'll lose sight of him. Only if I leave an area sufficiently far enough, he'll come back and meet with me which isn't always possible. I know I can listen out for him but visual indicators would be better. But none of this works if I sent him to a settlement but needed to find him and he hasn't returned yet.  Is there anything we can do to make locating companions in the world easier? terminal won't launch after install python 3.5 After I installed Python 3.5 and ran the commands below, my terminal and many other programs won't launch any more.  cd /usr/bin sudo rm python3 sudo ln -s python3.5 python3    How can I restore the default Python version again to fix these problems? Making leaflet control open by default I'm using leaflet to display a map.  I have a control section that I'd like to be open by default, but I can't find a way to do it through the . Is there a way to do this? If I'm playing the Hilltop farm in co-op - what farmer's mining level is used for the hilltop spawns? I'd say Microsoft have a way of bending the rules and I know that McLaren have won the championship. While this sounds strange, I believe it is correct English (sorry, I'm not native).   But when it's a small company, would you still use it this way? Is a company always plural, or are small companies singular? I.e., would you say Bakery Johnson makes fine bread or Bakery Johnson make fine bread? Is it My book seller, Woody's, have moved or is it has moved? PCA and proportion of variance explained PDF of function of X I'm learning about functions of random variables and am trying to work out an example I made up. If $y = \sin(x)$ and $x$ has domain $[0, 4\pi]$, is the following the correct expression for the pdf of $y$: $$\begin{align*} f_Y(y) &amp;= \frac{d}{dy}F_Y(y)\\ &amp;= \frac{d}{dy}[F_X(2\pi) - F_X(\pi) + F_X(4\pi) - F_X(3\pi)]\\ &amp;= \frac{d}{dx}F_X(2\pi)\left|\frac{dg^{-1}(y)}{dy}\right| - \frac{d}{dx}F_X(\pi)\left|\frac{dg^{-1}(y)}{dy}\right| + \frac{d}{dx}F_X(4\pi)\left|\frac{dg^{-1}(y)}{dy}\right| - \frac{d}{dx}F_X(3\pi)\left|\frac{dg^{-1}(y)}{dy}\right|\\ &amp;=f_X(2\pi)\left|\frac{1}{\sqrt{1-0}}\right| - f_X(\pi)\left|\frac{1}{\sqrt{1-0}}\right| + f_X(4\pi)\left|\frac{1}{\sqrt{1-0}}\right| - f_X(3\pi)\left|\frac{1}{\sqrt{1-0}}\right|\\ &amp;= f_X(2\pi) - f_X(\pi) + f_X(4\pi) - f_X(3\pi)\\ \end{align*}$$ I need to find a bottleneck and need to accurately as possible measure time.  Is the following code snippet the best way to measure the performance?  DateTime startTime = DateTime.Now;  // Some execution process  DateTime endTime = DateTime.Now; TimeSpan totalTimeTaken = endTime.Subtract(startTime);