tof

Recent Blog Comments By tof

• Performance Of LEFT OUTER JOIN Insert vs. INNER JOIN Delete Statement

  Posted on Aug 25, 2011 at 7:46 PM

  @Anna, Show us the queries :-). There's probably a tinny difference between the two. At the end of the day databases are like compilers, they do what you ask them to. Mostly ;-D... read more »

• Performance Of LEFT OUTER JOIN Insert vs. INNER JOIN Delete Statement

  Posted on Aug 24, 2011 at 9:25 PM

  @JoeM, I beg to differ (for MSSQL, anyway). While GROUP BY can achieve what DISTINCT does, it is meant for aggregation. i.e. if you just want to output distinct data without counting/summing... use DISTINCT, it's more readable and will end up using the same execution plan (namely a combina... read more »

• Performance Of LEFT OUTER JOIN Insert vs. INNER JOIN Delete Statement

  Posted on Aug 21, 2011 at 10:59 PM

  I agree with Matt, 28ms is not a slow query in the first place. And I wouldn't use time to measure performance on such a small scale. Better to look at the IO, CPU cost, and the sub-tree cost in your execution plan (as well as the plan itself). There's a million and a half things that can influence ... read more »

• Troy Valberg And The Powerlifters Of Equinox

  Posted on Dec 21, 2010 at 6:29 PM

  Back in 2001, right after uni in France, I got myself an internship at Siemens in Edison, just 5 minutes from there. That's where I wrote my very first line of CF and I'm pretty sure it had too many hash signs. Nostalgia...... read more »

• Let's Make A Deal - The Monty Hall Problem In ColdFusion

  Posted on Apr 6, 2010 at 2:32 AM

  "probability and statistics has never been my strong suit". Not sure the pun was intended but that's pretty goddamn funny :-D... read more »