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 3 of 3   
 

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,382 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,232 reads
   Items 1 to 3 of 3   
 
Tags
sql server 2014 (2)    
stairway series (2)    
administration (1)    
data warehouse (1)    
indexing (1)    
olap (1)