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

Content with tag Data Warehouse Rss

   Items 1 to 18 of 18   
 

Azure SQL Data Warehouse loading patterns and strategies

This article gives an overview of the Microsoft Azure SQL Data Warehouse architecture. The new platform-as-a service (PaaS) offering provides independent compute and storage scaling on demand and is currently in public preview.  Read more...
By Additional Articles 2016/02/19 | Source: SQLCAT | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,445 reads

Tips to Optimize Your SQL Statements - Part 2

Read more tips to optimize SQL statements, specifically on a Data warehouse.  Read more...
By Brian Ellul 2015/05/07 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 13,165 reads

Template - Type 6 SCD Stored Procedure

Template to create a Type 6 slowly changing dimension stored procedure  Read more...
By Marie Bayer 2015/02/17 | Source: SQLServerCentral.com | Category: template
Rating: |  Discuss |   Briefcase | 2,163 reads

ETL Performance Auditing - Part 1: Introduction to ETL Auditing

This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2014/10/31 (first published: 2012/06/05) | Source: SQLServerCentral.com | Category: etl performance
Rating: |  Discuss |   Briefcase | 17,095 reads

RegEx for DBAs

RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions  Read more...
By David Poole 2014/09/05 (first published: 2012/05/08) | Source: SQLServerCentral.com | Category: regex
Rating: |  Discuss |   Briefcase | 18,975 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 index
Rating: |  Discuss |   Briefcase | 4,704 reads

Template - Type 6 SCD Stored Procedure

Template to create a Type 6 slowly changing dimension stored procedure  Read more...
By Marie Bayer 2015/02/17 | Source: SQLServerCentral.com | Category: template
Rating: |  Discuss |   Briefcase | 2,163 reads

Mastering Dimensions of Time

A method to create and populate Date and Time dimension tables for a data warehouse project.  Read more...
By PhyData DBA 2014/01/21 | Source: SQLServerCentral.com | Category: data warehouse
Rating: |  Discuss |   Briefcase | 7,304 reads

Creating Inferred Dimension Members with SSIS

This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.  Read more...
By Robert Rubocki 2013/12/24 (first published: 2010/12/08) | Source: SQLServerCentral.com | Category: data warehouse
Rating: |  Discuss |   Briefcase | 9,629 reads

Getting Ready for Big Data: Prepping the Data Warehouse

Big Data implementations bring their own problems and issues, and will require database administrators and support staff to redesign the data warehouse architecture. Here's how.  Read more...
By Additional Articles 2013/12/02 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 4,346 reads

Why You Need a Data Warehouse

Introduction You likely have heard about data warehousing, but are unsure exactly what it is and if your company needs one....  Read more...
By 2013/07/25 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,744 reads

Low Profile Architecture

The goal of this article to show how to get unique transactions per client per month from the data set containing multiple transactions per client per month.   Read more...
By Igor Zaychik 2013/04/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,778 reads

Create and Populate a Date Dimension Table

Creates and populates a date-dimension table suitable for OLTP or data warehouse purposes  Read more...
By Joseph Morgan 2013/02/04 | Source: SQLServerCentral.com | Category: date dimension
Rating: |  Discuss |   Briefcase | 1,384 reads

ETL Performance Auditing - Part 1: Introduction to ETL Auditing

This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2014/10/31 (first published: 2012/06/05) | Source: SQLServerCentral.com | Category: etl performance
Rating: |  Discuss |   Briefcase | 17,095 reads

RegEx for DBAs

RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions  Read more...
By David Poole 2014/09/05 (first published: 2012/05/08) | Source: SQLServerCentral.com | Category: regex
Rating: |  Discuss |   Briefcase | 18,975 reads

Using The Kimball Dimensional Modeling Tool

Using the Kimball Data Warehouse Modeling Tool in an agile setting supporting regular builds and integrated testing with work a rounds to cover non-SQL Server systems.  Read more...
By Jim Nichols 2011/10/31 | Source: SQLServerCentral.com | Category: bi
Rating: |  Discuss |   Briefcase | 6,739 reads

Data Warehouse Development: Version 0

What do you do first when developing a data warehouse? MVP Andy Leonard brings us a look at the foundation he uses, which might surprise you.  Read more...
By Andy Leonard 2011/04/07 | Source: SQLServerCentral.com | Category: data warehouse
Rating: |  Discuss |   Briefcase | 8,950 reads

Creating Inferred Dimension Members with SSIS

This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.  Read more...
By Robert Rubocki 2013/12/24 (first published: 2010/12/08) | Source: SQLServerCentral.com | Category: data warehouse
Rating: |  Discuss |   Briefcase | 9,629 reads
   Items 1 to 18 of 18   
 
Tags
bi (2)    
columnstore index (2)    
date dimension (2)    
integration services (ssis) (2)    
sql server 2014 (2)    
t-sql (2)    
azure (1)    
big data (1)    
blogs (1)    
compression (1)    
data mart (1)    
database (1)    
database settings (1)    
datamart (1)    
dimension tables (1)    
dimensional modeling (1)    
etl (1)    
etl performance (1)    
excel (1)    
fact table (1)    
indexing (1)    
instance settings (1)    
kimball (1)    
loading patterns (1)    
max degree of parallelism (1)    
merge (1)    
olap (1)    
optimize for ad hoc workloads (1)    
partitioning (1)    
recovery model (1)    
regex (1)    
regular expressions (1)    
reporting services (ssrs) (1)    
scd (1)    
script component (1)    
slowly changing dimension (1)    
sqlclr (1)    
star schema (1)    
stored procedure (1)    
template (1)    
time dimension (1)