When setting up composite key indexes in SQL server, I have always thought that it is best to put the column that has the most variation first in the index. I've recently seen articles that claim this is a myth. 

So does anyone know the the facts here? Is column order important?

Regards, Tony