And I disagree because RI isn't the only reason to have a PK. 😉

Heh... and by the way... this...

T - you do whatever transformation or massaging is needed...

... sometimes means deleting duplicated data. 😉

PaulB (10/11/2008)

---

A delete on a staging table is like saying "I don't care about this row coming from the source application", if that actually happens either the Data Warehouse is...

GilaMonster (10/11/2008)

---

Jeff Moden (10/11/2008)

---

... and, here's the tests... these work on both 2k and 2k5. According to Gail's fine blog, some of these tests will not work on 2k8...

rbarryyoung (10/10/2008)

---

Tomm: That doesn't do the same thing. Note that if some EXCLUDEs match a LOCATION row and some do not, then it will return one or more...

PaulB (10/11/2008)

---

I love you too guys but not every table need to have a PK.

How about staging tables in a Data Warehouse environment?

As you should know Staging tables are nothing...

Outstanding explanation, Kenney.

On the recursive thing... do keep in mind that recurssion is nothing more than a loop and has the same performance impedements as a loop. In other...

Except for things like what Marios pointed out, I avoid table variables like the plague not only because of their "single record" execution plan, but because they are also more...

Guess I'll throw the testing I've done in the past into the ring... 🙂

The testing below takes the "display" out of the picture using a throw-away variable of the DATETIME...

Chris Harshman (10/10/2008)

---

Actually the DateAdd/DateDiff method seems to perform slightly better (like 6 milliseconds better over 25,000 rows) than...

ggraber (10/10/2008)

---

Nope, I'm not 100% sure I know what you mean by a "Tally CTE." Sounds like you're gonna create a tally table on the fly. Which sounds pretty...

rbarryyoung (10/10/2008)

---

And what bothers me most about this is that I know that it is not the extra formatting that is killing my speed, but the built-in formatting that BCP...

"Thorn" is actually the name of a character in the ASCII character set. A good description and history of the character is found at the following URL...

http://en.wikipedia.org/wiki/%C3%9E

Heh... I forgot about that. I'm...

Micheal, Noeld... thank you very much for the help. You guys are the best. 🙂 I'll let you know how it all turns out if they actually follow...