TomThomson (3/15/2016)

---

I believe that what Solomon is advocating is actually a lot worse than what Jeff is advocating, because his justification for it is that he wants to introduce yet...

Ed Wagner (3/14/2016)

---

spaghettidba (3/14/2016)

---

Solomon Rutzky (3/14/2016)

---

Well, for reasons heretofore stated and...

Well, for reasons heretofore stated and unstated, whether expressly or implied,...

Jeff Moden (3/12/2016)

---

since there's a work around for that, as well, I can live with the idea that the relational purists have of not returning anything because a string wasn't...

Jeff Moden (3/12/2016)

---

IMHO, what you have to remember is that, no matter what type of function it is, it's still "just" a string manipulation function, which makes it quite a...

TomThomson (3/11/2016)

---

So LOG returns NULL when it has NULL input. It doesn't return a rowset containing a...

Sorry to not respond sooner, but for some reason I never got a notification that there was a post.

Thank you...

Many thanks to David Poole for his time and help in peer-reviewing this article (i.e. Levels 6, 7, and 8) :-D.

Many thanks to David Poole for his time and help in peer-reviewing this article (i.e. Levels 6, 7, and 8) :-D.

Many thanks to David Poole for his time and help in peer-reviewing this article (i.e. Levels 6, 7, and 8) :-D.

Lot's goin' on here 😉

The "true" version of code is where you pull from when you are going to make changes....

A few thoughts:

1) As Steve mentioned, TRY_CONVERT is your ideal option, but since it was introduced in 2012 and you are on 2008 R2, that isn't an option (sadly).

2) Some...

deroby (1/18/2016)

---

However, since one can't use UDDT's on temporary tables (the UDDT sits in the current db, not in the tempdb) there is no way to do

CREATE TABLE #test...

MMartin1 (1/4/2016)

---

Solomon Rutzky (12/29/2015)

---

Eric M Russell (12/26/2015)

---

Well, im still not sure about RegEx in a data warehouse. Parsing text columns suggests things like product descriptions were not identified by category...

Hi Thomas. Good job raising the visibility of the DATABASE_DEFAULT option for the COLLATE clause.

Just a few notes about things mentioned in the article:

1) "CP1" is just a nickname /...