Chaitra,

Any feed back on this?  Was that the problem or something else?

Oh shoot... although the answer to the formula above may have originally been posted incorrectly, I think I finally get this process that you're looking for...  Not sure what the...

And, sorry, I'm still not getting it... (2(20)+2(20-15)) = 50... not 45... True?

You bet.  Thank you for the feedback, Ram.

Shoot, Lynn... I knew that... you knew that... I just wanted to make sure Kung Lao knew that.   Whether anyone suggests changing the server...

???  He's already deleted the data by mistake... how is either method you suggest going to recover data that's already been deleted?  

I agree...

The other thing about Carl's trigger, is that it will actually update more than 1 row in the DCParty table whereas the original trigger would only update one row in...

Nope... not a PATINDEX bug... and you don't need to mess with the server default settings (case sensitive servers are a huge pain!).

This will do it for you...

SELECT PATINDEX...

Sure... if the @Column_Name variable contains something less than 2 characters, then because of the "-2" modifier in it, BOOM!

Can't help much more than that 'cause I don't know what...

Back button has never worked for me

Good workaround, but a bit slow and resource intensive if you have millions of rows...

Something like the following works very fast... yeah, it does use dynamic SQL but that's only...

Why do you need a white paper on the fact that if two users use a function, they get their own answers?  It's that way with any function in any...

Also, almost forgot... you can shrink TempDB (by file) as with any other DB without bouncing the server (possibly as Sugesh suggested).  It could cause a fairly long wait time, though......

If the batch size of BCP/BULK INSERT is relatively small (less than a million rows, say), then those are likely not the problem.  Rumor has it that the extensive use of...

No... not ready to make that recommendation.  We first need to identify what change was made to cause the code to suddenly go south several days ago.  Quick fix would...