Technically, an Update is defined as a delete followed by an insert. If you had a delete trigger, you would see it firing as well.

You can verify this by creating...

I'm blown away by the responses to my article, and very much appreciate the comments posted, but does anyone know anything about the waits I didn't talk about. I would...

It's my opinion that both of you are correct.

Simonsabin is correct, in that by definition, which is what he says, it is a deadlock even if both processes waited 100...

great call, simonsabin.

ALWAYS set based over cursor, if possible. In my opinion, the time to use a cursor is when NO other functionality will work, as SQL Server LIKES...

LMAO....Bulk Insert IS BCP functionality internal to SQL, same format files, same processes. I couldn't swear to it but I believe Bulk Insert is a wrapper for BCP to allow...

The format info that I use is in the conversions. I store it in a table called ADMIN_Jobs which relates to another called Admin_JobsFields. I BCP the data into a...

I use quite a lot of linked servers, and examine execution plans almost daily and all of the execution plans show higher values against linked servers than they do when...

I agree strongly. XP_Sendmail is a godsend within a stored proc, but you would have to have a really good reason (business or process) to convince me to use vb...

Sounds like you want a server side trace. You can perform the same profiling that you do with profiler. I regret I don't remember the syntax off hand, and it...

Yes, joachim.verhagen, it is cumulative. The measurement is in milliseconds. The difference between Wait time and Signal Wait time is basically the difference in waiting on something and communicating about...

Yep.

I figured you were fighting developers. I've seen that idea come from some before. Had to prove it to them.....

Edited by - Scorpion_66 on 11/21/2002 4:59:01 PM

The scripts I sent you have examples of the usage of exec but with bcp instead. And in my example, I read the file specs from a table.

Also, if...

no. although I can see how someone might think it would.

They are thinking that the clustered index, being the data, would naturally have to be re-arranged because its the data....

I use XMLSPY. Although its not code itself, it makes generating it easy. They have a demo version. Download it and see if it doesn't make your life easier dealing...

the sql submitted by jensk2 would solve the issue, and I believe would be the best performer.

Indexes for the appropriate columns would of course, be great, but wouldn't actually...