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

Content with tags Data Warehousing, Partitioning 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: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 3,366 reads

Implementation of partition switching within SSIS

In the third part of a series on loading a partitioned data warehouse efficiently, we see how SSIS can be used to perform the ETL tasks.  Read more...
Rating: |  Discuss |   Briefcase | 4,595 reads

Partitioning Data in a Multi-tenant Data Warehouse Solution

Part two of our series looks at the partitioning strategy to separate customers' data, providing security and performance.  Read more...
By Sean Woehrle 2014/04/22 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 4,772 reads
   Items 1 to 3 of 3   
 
Tags
etl (2)    
columnstore index (1)    
integration services (ssis) (1)    
multi-tenant (1)