Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: | Category: partitioning
Rating: |  Discuss |   Briefcase | 3,108 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,486 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: | Category: data warehousing
Rating: |  Discuss |   Briefcase | 4,729 reads
   Items 1 to 3 of 3   
etl (2)    
columnstore index (1)    
integration services (ssis) (1)    
multi-tenant (1)