We may be old, but as long as we can learn new tricks, we're not too old. 🙂

I would be interested to know if there is something like this too.

Excellent suggestions Paul!

I changed the argument varchars from MAX to 1200 and that improved performance marginally ~5%. I switched the collation type and selected the top 60,000 again but...

Hi Paul,

thanks for your replies and corrections. I actually put together a version of your example that nests 31 REPLACE functions and then tested it against Jeff's while loop....

I see. So if you want to remove the full set of 37 unprintable characters, you would have to create 37 levels of nesting with REPLACE. I guess...

Paul,

when I run your example code, I get a separate resulting row for every character I'm trying to exclude. I don't see the same behavior in Jeff's code. ...

This article is in regard to indexes with included column on heap tables. This means the table doesn't have a clustered index, right? In our data warehouse, all...

If the purpose of this script is to detect whether two tables with identical structure have different data, it might be nice to check the row counts before jumping into...

For those of you still following this thread, I wanted to touch upon something I alluded to in the article. When I tested the performance of my two solutions,...

I would like to thank everyone for posting your comments and contributing to this discussion. I enjoyed reading along and have learned a few valuable tips and tricks in...