Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.


Member since May 20, 2010

Recent Blog Comments By Kees

  • Are SQL PATINDEX() And The SQL LIKE Clause Doing The Same Thing?

    Posted on May 20, 2010 at 1:11 PM

    In my blatently unscientific tests PATINDEX was slower than LIKE. I searched 176546 Descriptions for matches to eight strings: SELECT Count(*) FROM GSA_Work WHERE PATINDEX('%Storage%', Description) > 0 OR PATINDEX('%Storag%', Description) > 0 OR PATINDEX('%Storwks%', Description) > 0 ... read more »