I know this is an old thread, but I was faced with the same problem and found out some useful stuff.

I had a batch job that ran for 9 minutes.

By...

This is an old post, but I just fought thru some of these issues, and it might help somebody. (Maybe even me in a few months when I've forgotten....

Well, this answer is a bit late for you (I hope!!), but it might help someone else.

The biggest variable you gave us no info on is the network load aspects...

Is the ssms2008 tool on the same computer as the ssms2005 tool? Or a different box?

Because if it's a different box, you may be losing your user authentication crossing...

Trying to keep the CLIENT's identity value in YOUR identity column is a mistake.

Client A sends records with identities of 1-500.

Client B sends records with identities of 1-500.

Both want their...

Well, I've been using create or replace for over 10 years now.

I remember when I had to code in Oracle before it was introduced, and how much simpler the coding...

The point is that I don't have to write all of that code to test for it's existence.

GilaMonster (3/11/2010)

---

Post it on Connect and see how people vote. Posted here the dev team isn't going to see it.

quote]

Just signed up to it. I'll do that after a...

You are right, I could use alter if the object exists.

The whole point of "create or replace" is that I don't have to know, OR CARE, if the object exists!

It...

Dynamic SQL is over-used by ignorant programmers who do not know what a SQL Injection attack is, or by lazy unprofessional ones who don't care.

There can be performance penalties for...

I inherited a system where the database designer believed that identity columns should be used as the primary key because joins were faster that way.

This particular database design was a...

I think I would rather get my teeth drilled - every day - than use Visio to design a database with more than one table and column in it.

At one company, I convinced the CIO to budget 4 hours per week, per developer, for self-directed technical or business learning.

Staff were directed to pick their time and schedule their...

The average level of skill of IT workers is well below the professional level of skill needed to do the job right.

My complaint is that so few make ANY effort...

There are a host of excuses for being below average at a job. I've heard quite a few of them over the years.

99.9% of those excuses are pure BS.

Don't...