Lynn,

Too bad about that person.  We've still got one like that, too.  Dunno why they keep him around.

Say, that 3rd party app wouldn't happen to be a product called "Cost...

Spot-on on all points, Matt.  And, thanks for the reminder... I forgot that such tools just short office politics right straight to ground.

Lynn,

Sorry, got a bit distracted... I think your co-worker is spending way too much time monitoring performance.  HOWEVER, I've not had to walk in his/her shoes... it may be that...

Pet peeve... maybe a rant... (please forgive the forthcoming soapbox)... consider this carefully... no matter which "performance monitoring" tool you use, what good does it do you if you find a...

I am unable to duplicate the failure you say you are experiencing... that's not to say it's not happening... I just can't duplicate it because I don't have your data.

My...

Yes... it works fine... if you are only updating one row at a time... try updating more than one row at a time and see what happens... BOOOMM!

I'm looking at...

Nope... you made an unqualified statement with no conditions.  And no one would force such an index as you have because everyone knows the bookmarks will kill any hope of...

Dunno about others but I only use DTS for one off, ad hoc copies of data.  If it goes into production, I use either BCP or Bulk Insert.  I don't...

You are missing joins between the PK of the INSERTed and DELETEd tables in all such SELECT's in the code you posted...

Recommend you change them all similar to the following...

Now, there's a plug I can agree with... AND, if you take the time to study it in Books OnLine, you'll find that it's capable of doing such things as...

Sreemati,

The list isn't what you think... it's a bit sarcastic and starts off with something like "#1.  Write good code."

The big key is as I said... think columns, not rows. ...

Carla,

I just used your query on a million row table and it returned all the columns for 275K rows in less that 6 six seconds... what is the datatype...

Problem solved... ALZDBA reminded me of the other collation...

Both of these work (did positive testing instead of negative testing this time, my bad)...

DECLARE @FIND VARCHAR(8000)

    SET @FIND...