Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Data Warehousing, ColumnStore Index Rss

   Items 1 to 3 of 3   

A Tale of Partition Schemes and Disappearing Dragons

A tale in which is detailed how I used SWITCH PARTITION to efficiently load my data and save myself from the flaming jaws of death.  Read more...
By Porter James 2015/11/02 | Source: | Category: partitioning
Rating: |  Discuss |   Briefcase | 3,414 reads

Column Store vs Row Store Indexes

How does a column store index compare to a (traditional)row store index with regards to performance  Read more...
By Brian Ellul 2015/05/14 | Source: | Category: columnstore index
Rating: |  Discuss |   Briefcase | 7,879 reads

Column-Store Databases and DW Appliances

With data volumes exploding, conventional enterprise data warehouses are fast running out of headroom. Data warehouse appliances are starting to fill the gap, but the emerging category of column-oriented databases may offer a better option. The key to success is matching your application to the right product.   Read more...
By Additional Articles 2008/03/25 | Source: SearchSQLServer | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 1,743 reads
   Items 1 to 3 of 3   
clustered column store indexes (1)    
covering indexes (1)    
etl (1)    
partitioning (1)    
row store indexes (1)    
sql server 2014 (1)