Many SQL Server operations can often be made faster by taking advantage of effective clustered indexes. It should be understood that this combination of a non-clustered and clustered index on the same ...

In this case, MS SQL will read the entire page with all the columns and "give back" only the necessary data. This leads to excess data reading, and therefore, reduces productivity.

SQL Server 2014 will offer Clustered Columnstore Indexes. These will offer the performance and compression benefits of column-oriented storage without the need to restrict the underlying table to ...