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 cf.Objective() 2010 (Minneapolis, MN) with: Jamie Krug

Tom

Member since Dec 11, 2008

Recent Blog Comments By Tom

  • What Chinese Food Has Taught Me About Life

    Posted on Mar 27, 2009 at 6:49 AM

    <blockquote back at you>Dude, these people swam the Pacific Ocean with daggers in their teeth and a kid under each arm to open a restaurant here. What good would your instructions on security have served getting them where they've been to where they are now? Look at the time y'all are devoting... read more »

  • What Chinese Food Has Taught Me About Life

    Posted on Mar 26, 2009 at 5:56 PM

    I'm not a salesman, but I *have* taken sales and marketing courses in order to learn client requirements and needs, and one of the things that you immediately are taught (and apparently some never remember :-( ) is that for every ONE person that complains, you have already lost NINE other customers ... read more »

  • SQL CHARINDEX() Has Data Size Limitations

    Posted on Sep 24, 2007 at 9:50 AM

    @Nathan: Right, TEXT, NTEXT and IMAGE datatypes are not stored like other datatypes. Basically, the column contains a pointer to where the actual values are stored, which might also have another pointer that chains to another location where more of the value is stored. Since it is variable length... read more »

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

    Posted on Sep 24, 2007 at 9:39 AM

    The biggest reason for using or not using PATINDEX probably would be whether or not you need the location of the value...maybe you might want to parse the value for some reason, like doing a replace on Sexy with another piece of text, or extract the value to use elsewhere. PATINDEX is kind of like ... read more »

  • SQL CHARINDEX() Has Data Size Limitations

    Posted on Sep 24, 2007 at 8:39 AM

    It sounds like it craps out on the 8k character limitation for the datatype you used (TEXT). Since you set up the in memory table to use TEXT, you probably couldn't buffer more than that into the column anyway, so maybe it is truncating without throwing an error; I know if you try to do an insert ... read more »