Michael Valentine Jones (1/2/2008)

---

I prefer to write date queries in the form of greater than or equal to a start date time, and less than an end date time. ...

Kenneth Fisher (1/2/2008)

---

Jeff,

Would this have been faster

SELECT *

FROM yourtable

WHERE yourcolumn LIKE '[12][089][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9]'

AND ISDATE(LEFT(yourcolumn,4))=1

i.e. Restrict the 1st...

Instead of adding "1"...

Heh... well done, Kenneth... that's one of my favorites, as well. The only time you really need a "split", is if you have to insert the rows into another...

Ian Yates (1/2/2008)

---

This was a great article to read - well written, not preachy and didn't contain factual errors. I suspect like many others on here the reason to...

Eric Stimpson (1/2/2008)

---

I think that when learning SQL, it is really important to map each SQL expression to an English (or your native language) equivalent so that you learn to...

Eric Stimpson (1/2/2008)

---

The actual performance tuning principle that this article touches on is the difference between distinct and group by constructs....

My message would be to challenge any use of distinct...

Cool... another bullet for the gunbelt....

JJ B (1/2/2008)

---

Nice, easy-read article. It even introduced me to a new function (CheckSum), which I looked up when reading your article. I particularly appreciated the code comments....

Michael Skinner (1/2/2008)

---

Great article.

What drives me insane about issues like this one (and I have had to create comma delimited files far too often through SQL) is that...

sushila (1/2/2008)

---

Jeff,

What an absolutely well-written and informative article - I totally agree with the earlier post that remarked on this being a great way to start the new year. I...

Correct... and thanks for the feedback!

Heh... thanks for the feedback, Donald. I'm right there with ya on the 10 tries. 😀

Like Colin was kind enough to point out, if folks think they can...

Perfect... thanks, Gail.

Now, there's a decent tip... 🙂