Disappointing

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Arup Chakraborty » Disappointing

Disappointing

Rate Topic

Display Mode

Topic Options

Author

Message

dalcock

Posted Friday, November 27, 2009 8:40 AM

Valued Member

Group: General Forum Members
Last Login: Monday, August 06, 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

dalcock

Posted Friday, November 27, 2009 8:41 AM

Valued Member

Group: General Forum Members
Last Login: Monday, August 06, 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 »

Permissions