marvin.elder (3/8/2010)

---

Tom,

So you're "down" on Chris Date? Don't you give him credit for authoring the most widely used textbook on relational database structure and SQL?

Or is it that you...

I'm sure he will soon.

Worrying about...

Good question, correct answer (well, it does depend on how one interprets "platform" but it's correct for what I think is the natural interpretation) but the explanation is a little...

I'll be the second pedant then.

Maybe it's my browser or maybe it's the article, but things like

Replace IIF with CASE, the becomes the WHEN clause, and the is the...

bitbucket-25253 (3/7/2010)

---

Never had anyone return from suspension, and no legal action bought against the compnay. True was in U.S.A. so do not know if it would hold up legally...

Maybe I shouldn't do this, but here goes:

---

With the following query:

WITH...

Nice question. I hadn't a clue, so today I made time to read all the BOL stuff about FILESTREAM, so today I have learnt more than most days.

Can't imagine why...

Steve Jones - Editor (3/7/2010)

---

Tom,

unfortunately I think it is much harder than that to fire someone. At least on a first offense. I agree with you, but I wonder if...

Very useful article. I've been using SQL2008 for a while, but hadn't picked up on some of the simple changes - maybe now I'll remember some of them. ...

I read your...

Ron Kane (3/2/2010)

---

I agree and am slightly concerned that anyone would ever look at posting the data and think it was a good idea.

But in the UK we have a...

Roger L Reid (3/2/2010)

---

A nice improvement on the original, Timothy. So many developers never get past the point you started at.

May I recommend picking up "The Art of SQL"...

Karen Lopez - InfoAdvisors (3/2/2010)

---

Oddly enough, I'm getting lots of push back from developers these days that having such tables is "bad design". I'm trying to track down a...

David Portas (3/3/2010)

---

The ideas in RM/T are interesting but I think it's fair to say that they have since been superseded by much more comprehensive work on semantic modelling, such...

RBarryYoung (3/4/2010)

---

Not only can you write procedurally in SQL, but you must and indeed, SQL must be designed not only to allow it, but to require it. Why?...