Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Disappointing Expand / Collapse
Author
Message
Posted Friday, November 27, 2009 8:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 6, 2012 3:06 AM
Points: 63, Visits: 53
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.
Post #825641
Posted Friday, November 27, 2009 8:41 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 6, 2012 3:06 AM
Points: 63, Visits: 53
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.
Post #825642
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse