The Essential Guide the SQL Server 2014: Clustered Columnstore Index

http://ift.tt/1JCyMXO

Learn about SQL Server 2014's enhanced columnstore index

In this Essential Guide to SQL Server 2014 series I’ve been covering the most important new features and enhancements that Microsoft added to SQL Server 2014. In the last column I covered the SQL Server 2014’s Backup Enhancements. In this column I’m going to cover the important enhancements to the columnstore Index. Microsoft introduced the columnstore index in SQL Server 2012 and it provided significantly improved performance for data warehousing types of queries.

read more

from SQL Server Pro http://ift.tt/1kCjeYg