THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and provides consulting and training courses around the world in SQL Server and BI topics.

Function Invertability for SARGability

Hi! - Great that you've found this page, but it's no longer here! You can find the content over at: http://blogs.lobsterpot.com.au/2011/03/24/function-invertability-for-sargability/

Published Thursday, March 24, 2011 12:42 PM by Rob Farley

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Alexander Kuznetsov said:

Rob,

I don't think this is such a good idea. The requested feature is not a must have, there is a very easy workaround. It is a nice to have feature we can live without.

Adding non-essential features slowly kills systems. Ray Ozzie's parting memo to Microsoft is a very good read.

More specifically, the following discussion on Bart Duncan's blog illustrates how complex it is to make any changes to a complex system:

http://bartduncansql.wordpress.com/2011/03/03/dont-depend-on-expression-short-circuiting-in-t-sql-not-even-with-case/

More features does not always mean a better system. In many cases less is more. Just look at the lightning fast Chrome. Look at the recently released Mozilla, which is almost not advertised at all, yet downloaded by millions. Look at Git - it is very simple, not much advertised, and its popularity grows exponentially.

March 23, 2011 10:59 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

News

News? Haven't you read my blog?

My Company


Can't find something?

Contact Me

IM: rob_farley@hotmail.com
Twitter: @rob_farley
Skype: rob_farley
E: rob_farley@hotmail.com

MVP (SQL Server)




Certifications








Adelaide SQL UG

Privacy Statement