Do you have a script to do this one at a time?

Do you know what *= means?

I just started going through the free chapter... glad to see there's some consideration for writing good code in there... maybe there's more in the rest of the book, but...

None of the bullets in the article include one of the most important aspects of performance tuning there is... one, that if not present, will bring the most robust hardware...

Heh... I was going to include "C" programmers in that mix :D, but wasn't sure it was true and I work mostly with Java programmers to boot.

Also, the Server account must be an account that has the privs to see the file. So does the user running the Bulk Insert... doesn't matter if they have...

We had similar problems with many features of SQL Server when we shifted to Windows Authentication... they all went away when we granted the machine account extra privs on it's...

ed.nettestad (11/6/2007)

---

I've read SQL 2005 now has a max variable size of 8k, but ours is still at 4k. Is there a setting somewhere that can easily be changed...

Just a thought... I don't have 2k5 so I'm not sure how to get there... but questions like this not only deserve the fine response above, but you just gotta...

The title of this article is "Parallel Processing of Large Volume ETL Jobs"... what do you consider to be a "Large Volume ETL Job"?

Karim Hemani (11/7/2007)

---

Yes, it's true that this is a duplicate post. There were two reasons why I posted the same question here:

1. The final reply confirmed that I was not...

Glad it worked out, John... I misunderstood thinking that you wanted to add a additional condition to an existing join. And, thanks for the feedback.

Heh... that's part of the point, Gail. If business users write it as a requirement, they need to be educated because it's wrong. If auditors get nervous because...

AND

Oh yeah... here it is...

http://www.sqlservercentral.com/Forums/Topic418836-169-1.aspx