tof
Member since Apr 6, 2010
- Profile: /members/5776-tof.htm
- Comments: 5
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 »