Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Data Warehouse Rss

   Items 1 to 13 of 13   
 

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 | 3,866 reads

Template - Type 6 SCD Stored Procedure

Template to create a Type 6 slowly changing dimension stored procedure  Read more...
By Marie Bayer 2014/03/05 | Source: SQLServerCentral.com | Category: template
Rating: |  Discuss |   Briefcase | 1,203 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,181 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 | 8,551 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,179 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,017 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,720 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,239 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 2012/06/05 | Source: SQLServerCentral.com | Category: etl performance
Rating: |  Discuss |   Briefcase | 9,102 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 2012/05/08 | Source: SQLServerCentral.com | Category: regex
Rating: |  Discuss |   Briefcase | 10,149 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,508 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,862 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 | 8,551 reads
   Items 1 to 13 of 13   
 
Tags
bi (2)    
date dimension (2)    
integration services (ssis) (2)    
t-sql (2)    
big data (1)    
blogs (1)    
columnstore indexes (1)    
data mart (1)    
database (1)    
datamart (1)    
dimension tables (1)    
dimensional modeling (1)    
etl (1)    
etl performance (1)    
excel (1)    
fact table (1)    
indexing (1)    
kimball (1)    
merge (1)    
olap (1)    
regex (1)    
regular expressions (1)    
reporting services (ssrs) (1)    
scd (1)    
script component (1)    
slowly changing dimension (1)    
sql server 2014 (1)    
sqlclr (1)    
star schema (1)    
stored procedure (1)    
template (1)    
time dimension (1)