Novices have no business designing databases, so I won't reiterate all the bad patterns related to that. Instead I'll mention a few observations regarding common mistakes that end users make...

Hopefully R# will be to data analytics what C# is to application development, and it won't simply be a curious wallflower like J# and F#.

R is good, but R# will be even better.

You can use the following stored procedure and DMV queries to get information about server disk space. Because it runs within context of SQL Server, you only need connect to...

Sorry about that; I forgot to add Y.ID = T.ID in the join, which is why it was previously cross...

Miles Neale (3/17/2015)

---

Eric M Russell (3/17/2015)

---

Miles Neale (3/17/2015)

---

I agree, however the lawyer would say that there is no proof that the digital representation has not been altered or completely fabricated...

select T.ID, T.Amount, Y.Amount as Yesterday_Amount, T.InjectedDate

from Transactions as T

left join Transactions as Y

on cast(Y.InjectedDate as date) = dateadd(day,-1,cast(T.InjectedDate as date))

order by T.InjectedDate, T.ID;

If join performance...

Miles Neale (3/17/2015)

---

Eric M Russell (3/17/2015)

---

Miles Neale (3/17/2015)

---

Eric M Russell (3/17/2015)

---

It seems we need to better define what it means to "witness" a crime. For example, if a city clerk...

Miles Neale (3/17/2015)

---

Eric M Russell (3/17/2015)

---

It seems we need to better define what it means to "witness" a crime. For example, if a city clerk manually reviewed each photo of...

Charles Kincaid (3/17/2015)

---

...

A traffic violation is a misdemeanor (minor crime). A charge like that has to be brought either by an officer or citizen. But that individual...

This would be an excellent interview question for those situations where someone has a personal grudge against the candidate. :crazy:

Gary Varga (3/17/2015)

---

Part of me believes that in this century we may move to a model where ownership of data is considered "so 20th century", however, where value can be...

Microsoft Team Foundation Server has a feature in it's source control where you can compare one version of a source file to another past version, and it will highlight all...

SQLRNNR (3/13/2015)

---

I have seen a couple of comments in this thread about the type of comment that states the obvious.

I don't necessarily take issue with a comment that states the...