The absolute worst type of comment is when a developer encloses a pre-existing block of code within /* */ brackets without an additional comment stating why, when, and who.

Another type...

Hey JeeTee,

So which of these ponies runs fastest?

I'm placing my money on the INSERT #S EXEC() AT method I described earlier.

:satisfied:

Xavon (3/12/2015)

---

One thing I would like to add to this:

namely:

"or is saddled with...

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