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 …
Blog Posts
Now before we dive into the variety of reasons for using a view, let’s first briefly understand what a view is. To put simply, a view is a stored single …
