Skip to main content

William Bowen

Member since Dec 11, 2008

Recent Blog Comments By William Bowen

  • Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

    Posted on Mar 28, 2008 at 1:53 PM

    @Jeffrey, Fair points, reasonable rebuttals, I probably won't address them all (a lot of them get more into matters of opinion/personal experience). A note about the constants. I don't want to have to pass them different places (including the database). That's why they get created in an easily ava... read more »

  • Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

    Posted on Mar 28, 2008 at 9:36 AM

    @Jeffrey Bouley - One good reason I've found to support application SQL versus stored procedures is the fact that I get to leverage my constant variables in the SQL I wrote within the application, versus having to define them again in my DBMS or hard code those values. That can be very handy for tr... read more »

  • Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

    Posted on Mar 27, 2008 at 3:00 PM

    I think when you say "Never Join Tables Using Commas" you're really advocating two things: 1. Don't use a FULL OUTER JOIN (this is what happens if you take the full cross-product with no WHERE or ON). I can't ever remember a time where I even needed one. 2. Use ANSI-standard SQL joins (e.g., FROM t... read more »

  • Kinky Solutions Valentine's Day Give Away

    Posted on Feb 5, 2008 at 2:43 PM

    Hey Ben, My girl Katya is swell because she loves ColdFusion, knows the difference between Java and JavaScript, validates her XHTML to W3C standards, strictly scopes all her variables, and writes reusable modular code. Well, in my dreams she does. But I looked past those shortcomings and instead ... read more »

  • Ask Ben: Simple Recursion Example

    Posted on Dec 5, 2007 at 12:06 PM

    Good article, and there are tons of practical applications of recursion. Some of the most common tasks I find myself applying recursion to are multi-tiered menus and breadcrumbs. I've seen some more novice programmers use a finite series of loops as Ben suggested and then set an "unlikely" upper bo... read more »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
— Ben Nadel