Good question, nice easy start to the week.

Hugo Kornelis (2/1/2013)

---

That all being said - one other poster (I think it was Tom, but not sure anymore) found a smart way to extend Jeff's method to raise an...

Dineshbabu (1/31/2013)

---

Hi tom,

I don't think there will be a real need of chaining computed columns. Whatever experssion may be, we can...

archie flockhart (1/31/2013)

---

My guess is that is makes it much easier if they don;t need to deal with the...

Blake's 7 was better. 🙂

nice simple question.

I wonder why MS has this restriction?

It's getting worse - only about 48.5% (83 out of 171) got it right so far.

Nice question, but it's rather...

Owsley

Hugo Kornelis (1/29/2013)

---

I too think that every serious SQL Server professional (hmmm, that should a tautology) should have access to a sandbox SQL Server instance in an isolated environment, where...

Sean Lange (1/29/2013)

---

It seems that today's QOTD fits in nicely with this discussion. A very simple method was presented there using a constraint to allow a table to have only...

bitbucket-25253 (1/29/2013)

---

davoscollective

A lot of people are complaining about not having SQL Server 2012 or Adventureworks on production machines. I have a test/dev VM with SQL Server 2012 SP1 and both...

Hugo Kornelis (1/28/2013)

---

I though I understood the difference between STDEV and STDEVP, but apparently - I don't. And the explanations in Books Online don't help me either.

STDEVP: "the statistical standard...

Like several others, I don't like this question. Not one bit. There's no sane way to answer it without runing code, and for those of us without sql...

Nice easy question.

But I agree with what demonfox and Hugo said about thw explanation.

Hugo Kornelis (1/28/2013)

---

If you develop code that has to compute the statistical standard deviation...