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

Articles with tag Data Warehouse Rss

Search for any content tagged data warehouse

   Items 1 to 10 of 10   
 

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,509 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,153 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,499 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,171 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,714 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,089 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,133 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,497 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,860 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,499 reads
   Items 1 to 10 of 10