very good post! I am a big fan of CTEs and CROSS/OUTER APPLY but like many said above sometimes temp tables make the code more efficient and maintainable, so experienced...

one of the most interesting posts I've read recently, very cool!

great post, I bookmarked it for my next project. I was also looking at scripting with winscp but I think this approach is more SSIS friendlier that custom scripting and...

keep in mind many people who started working with SSIS, have very little or no experience with dedicated ETL tools. In fact, a huge lot of companies still code ETL...

great test and article!

I did similar tests 2 or 3 years ago and was looking at SSIS, Talend and Pentaho. A lot of things changed since then but looks like...

i also found that performance of MERGE is a bit worse than just INSERT/UPDATE - with indexes in place - it is not a huge difference but still noticeable.

Also it...

awesome, it will work! thanks for the quick response, Jeff! and I am going to use this opportunity to say BIG THANK YOU...

Jeff, thanks for the great articles (part 1 and part 2 and look forward to part3).

Is there a way to pick a random value (like a color) from a subquery?...

wow i could never guess that could be the issue! it helped me, thanks for sharing the link!

thanks, I appreciate your help!

thanks,yayomayn, for an explanation. This is what I was going to do but I am still puzzled how to handle occasional deletes to a fact table. Any ideas? my fact...