We solved this problem by creating a persisted computed column that contains no punctuation and no spaces.  When the user types something to search for, we also strip that of...

When you realize what they just did in code...

I dunno... seems like a lot of people try to jump through unnecessary hoops to do such things.  I've got a plain ol' linked server between two of my boxes...

A couple of decades ago, long before the words "Test Driven Development" ever parted anyone's lips, we called such reliable and safe test data a "Gold Set".  And, yes, if...

Heh... this is a very old article... I don't believe I even knew what an implicit conversion was back then. 😀

Anyway, thanks for the science, Eirikur.  Being a...

Not sure if you're talking to me on that message,...

Heh... having served aboard submarines, I can tell you that you simply don't ever need to clean the hull.  Just take 'er out into some deep water and put some...