Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at BFusion / BFLEX 2009 (Bloomington, Indiana) with: Simon Free

Kees

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 »