You can successfully ping remote server name from client?

GoofyGuy (3/11/2015)

---

I'm actually beginning to question the relevence of in-house database engineers. It's not that we can't make a real difference, it's just that circumstances beyond our control marginalize the...

pbyrum (3/11/2015)

---

I have SQL Server 2012 installed and when I run this command:

sc query mssql$MSSQLSERVER

I get this error:

[SC] EnumQueryServicesStatus:OpenService FAILED 1060:

The specified service does not exist as an installed...

ddudley-847177 (3/11/2015)

---

This is why in the old days the conventional wisdom was that the more experienced did more design while the less experienced did the maintenance. It is now reversed....

jonesboy21 (3/11/2015)

---

I could write an article about it, not sure how much information I could give out though due to confidentiality agreements. We did have large SQL Server enterprise servers...

Wow, that's so geeky. But it is funny and true....

I'm guessing this retail giant does have SQL Server...

I'm guessing that Symbols is essentially a reference table containing one row for each company or index fund traded on a stock exchange. If that's the case, then this was...

JeeTee (3/9/2015)

---

Hi All,

I have two servers (lets call them sA and sB) connected from sA -> sB via a linked server (i.e. sA pulls data across from sB).

I'm building a...

xsevensinzx (3/10/2015)

---

Koen Verbeeck (3/10/2015)

---

Eric M Russell (3/10/2015)

---

Did I understand you right that the query took 20 days?

A medium powered server should be able to perform a full table scan of...

xsevensinzx (3/10/2015)

---

ScottPletcher (3/10/2015)

---

If the table is already clustered on time (hooray!), then reading a week's worth of data shouldn't take that long.

We need to review two things (at least).

First, the...

Charles Kincaid (3/10/2015)

---

Eric M Russell (3/10/2015)

---

In other words, if you update a MongoDB document, perhaps something like adding additional office visitation records to a patient's chart, then the change of...

Andrew..Peterson (3/10/2015)

---

About a year ago, a big technology company started a complete re-write of their applications, with the initial hope of completely eliminating their relational database system. Their initial goal...

Disclaimer: I have no practical experience with MongoDB at this point, so if my assumptions below are wrong, then please let me know.

I can see MongoDB as an ideal...

CREATE CLUSTERED INDEX IX_UNIQUE_KEY ON MRP.Margin_Optimization_Data (UNIQUE_KEY);

If IX_UNIQUE_KEY is intended to be a unique key, then you probably want to add the UNIQUE keyword.

CREATE UNIQUE CLUSTERED INDEX IX_UNIQUE_KEY

ON...