sandippani (5/11/2013)
Nice attempt. Here in this article you should explain why SQL server does like this. I'm referring to the Index Statistitics.
It's not due to statistics. It's due to the fact that you can only seek on a left-based subset of the index key.
You can also mention in the article that if all of the columns are used as predicate, order doesn't matter more precisly it is about the leading column of the index matters not the order.
The order still matters, especially if some of the predicates are inequalities.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability