November 27, 2009 at 8:40 am
I'm sure I will receive much abust for this post, but I'm going to share my thoughts anyway because I am a big fan of SQLServer Central and I care about the quality of its content.
That being said, I found this article extremely disappointing on many levels. First off, as has been mentioned already, operator precedence and the result are identical for the expressions (X * Y) / Z and X*Y/Z. Second, as the author mentions, SQL is built upon set theory and the performance of set based operations dramaticaly outperforms sequential operations, which is why I can't understand why the artical is demonstrating alternatives to set-based solutions when a real-world premise for doing isn't even identified.
Last, there are several set-based operations that can accomplish sophisticated updates (like using ROWCOUNT) that numerous prior articles on this very site have identified. So, as I said, I am very disappointed with this article and fail to see how it is relevant (or helpful) at all to SQL programmers new and old.
November 27, 2009 at 8:41 am
Sorry to all. This was intended to be a reply not a new topic. I have posted my reply to the article as I intended to originally.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply