george sibbald (1/2/2008)

---

Jeff, if people are actually going to listen to me 🙂 I better clarify my point....

an object created by a sysadmin will always be owned by dbo...

Heh... HOT DAMN! A kindred spirit! 😀

There is a third option that lot's of folks forget about... that is the one of a formula in the code instead of an extra join or a dip on...

Aye... nicely done... glad to see you back in the swing of things.

Yep, I'm aware that ROW_NUMBER doesn't imply NOT NULL like IDENTITY does...

... but both Itzek's method and...

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