Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Columnstore Indexes Rss

   Items 1 to 5 of 5   
 

Columnstore Indexes

By Dawn Strickrott 2015/03/16 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,509 reads

Stairway To SQL Server Columnstore Indexes Level 1: A First Look At Columnstore Indexes

This level introduces of you to the fundamentals of columnstore indexes, introdused in SQL Server 2012 to manage the indexing of very large tables.  Read more...
By Hugo Kornelis 2015/02/25 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,787 reads

Stairway To SQL Server Columnstore Indexes

SQL Server 2012 and later offer a very different type of index from the traditional b-tree, the in-memory columnstore index. These indexes use a column-based storage model, as well as a new "batch mode" of query execution and can offer huge performance increases for certain workloads. But how are they built, how do they work, and why do they manage to have such a dramatic impact on performance? In this stairway, Hugo Kornelis explains all, with his usual mix of concise description and detailed demonstration.  Read more...

Columnstore changes

By Steve Jones 2014/10/07 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,420 reads

Columnstore Index Changes in SQL Server 2014

SQL Server 2012 introduced columnstore indexes, which can immensely improve the performance of OLAP queries. How were they updated and improved in SQL Server 2014?  Read more...
By Edward Pollack 2014/07/24 | Source: SQLServerCentral.com | Category: columnstore indexes
Rating: |  Discuss |   Briefcase | 4,397 reads
   Items 1 to 5 of 5   
 
Tags
sql server 2014 (3)    
stairway series (3)    
indexing (2)    
administration (1)    
columnstore storage (1)    
data warehouse (1)    
olap (1)    
sql server 2012 (1)