Sorry, my question was more directed at the original poster. If we're talking about a large table, then we invariably could be in...

As painful...

Would the for each solution mean 28 different queries against the table? Is this a problem?

How wide is the dimension, and are we talking type 1 or type 2 SCD columns?

ammo (8/26/2009)

---

At my last job they were just starting to consider a "DW appliance" from Netezza

(http://en.wikipedia.org/wiki/Netezza). I guess the DW world got it first due to the massive...

I appreciate the overall message of "take a step back". This can be used in a lot of situatations when any problem arrises. Gather information and properly aim...

"Put tempdb on its own drive."

The is certainly not bad advice per se. But, applying this rule cart blanc is not good either. I've seen smaller shops deploy...

Steve Jones - Editor (1/7/2009)

---

I just don't think there's a good way to do this. I've seen the nuclear industry try, and they kill more trees than you can imagine...

A 10 page "Architecture" document hilighting key architectual decisions shouldn't be too hard to create. Heck, this can even be a PowerPoint slide and kept with your source code....

As a consultant, it is my job to document my work. More often than not, those that will support what I've done will be below my skill level (which,...

On Hints, I have to agree with the article that states that this is part of procedural programming and should not be considered set-based processing. The difference here is...

That's not clever, that's just retarded.

Somewhere along the line, business users got real scared about deleting data, especially with all this post-Enron regulation, and application architects have never really made data archiving a priority in...

Consider using a Data Conversion Transformation to change the datatype of the input columns before comparing them.

Try using an OLE DB Source instead. Sometimes my Derived Column transformations would still default to Unicode, but those were easy to change back.