This is pretty cool... we have several complex, multi-step store procedures and some folks have put some pretty complex logging procedures in them just so they can query a...

How simple... how elegant... I never knew you could do this... nicely done.

We sure don't need a cursor for this and I'm not sure you could do it any faster or easier in the client ...

What... replace one form of RBAR (pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row") in the form of a correlated sub-query for another form?  I don't know...

Sure... right after you tell us why you can't use xp_filesize so we don't recommend something similar...

Nice article, David, as usual...

As you are aware, I suspect that any performance differences will only occur where joins of different data types occur due to implicit conversions... but...

Yep...  you're supposed to know what the bad rows are BEFORE you begin the transfer.

Heh... my turn Remi... how come no Tally table here?  "I'm surprised you didn't think of it"

Here... shoe-horn a call to this function into my previous code to get rid of all but the required "pattern" of characters...

CREATE FUNCTION dbo.CleanData(@sText AS VARCHAR(8000),@pattern varchar(8000))

RETURNS VARCHAR(8000)

    ...

Thanks for the feedback Jules... I always wonder if anyone actually runs these things

Like I said, how long does it take on...

David...

What do you call "huge?"   How many denormalized rows are we talking about?  I work with a denormalized input from a million customer IVR and there are currently almost...

I appreciate the compliment but I didn't do anything... my comment was actually directed to Mohammed's fine and easy solution. 

John is correct... using the system tables would certainly work,...

So... how many rows must you examine (do this for)?

Cache.  It's not supposed to happen but I've seen it before.  Could be something else but I'd have to see all of the code to figure it out.

Views of views of views to feed DTS... I once raised my arm over my head in a very funny way and it hurt like hell.  I went to the...