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...

DBA's arn't born cranky; it's an acquired attitude. It does seem to me that unqualified developers (at least in terms of database design) get the first crack at a new...

GoofyGuy (3/9/2015)

---

'Web service'.

Abstracting out the database layer from the application offers a number of advantages -- not the least of...

I wish that Microsoft would put a bit more development into the SSMS Database Diagrammer tool. It's OK, for basic modeling, but it's limitations quickly become apparent when it comes...