Sr. Developer in my organization asked me following question:
Question : Does order of conditions matter in WHERE clause? If we move the conditions in WHERE clause does it increases the performance? Does SQL Server WHERE conditions supports short circuit?
In SQL Server order does not matter in WHERE clause. SQL Server does not short circuit conditions as well it does not help in performance.
Reference : Pinal Dave (http://blog.SQLAuthority.com)