Does the order of criteria the WHERE clause matter?

Does the order of the search criteria make any difference in Microsoft SQL Server's ability to use indexes or resolve a query? In this post, Joe provides a demonstration of how SQL Server can optimize the WHERE clause to its benefit.