Have you ever been in the situation where you were creating an index that required more than one column in its key and thought, “Hmm I wonder if the order here matters?”. To put it simply: yes, it does. The order of the columns matters when it comes to improving performance of queries in your SQL Server. In this post we’ll be going through a few short examples and observing how different column orders behave with the same query. I used …