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

Content with tag Data Warehousing Rss

<< Newer    Items 41 to 60 of 317    Older >>
 

Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries

In this white paper we discuss two of the new features in SQL Server 2008, Star Join and Few-Outer-Row optimizations. We test the performance of SQL Server 2008 on a set of complex data warehouse queries designed to highlight the effect of these two features and observed a significant performance gain over SQL Server 2005 (without these two features).  Read more...
By Additional Articles 2009/09/10 | Source: Microsoft MSDN | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 3,819 reads

Implementing a SQL Server Fast Track Data Warehouse

This paper defines a reference configuration model (known as SQL Server Fast Track Data Warehouse) and a CPU core-balanced approach to implementing a symmetric multiprocessor (SMP)-based SQL Server data warehouse with proven performance and scalability expectations for sequential I/O data workloads.  Read more...
By Additional Articles 2009/09/04 | Source: Microsoft MSDN | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 3,535 reads

Kimball University: Five Alternatives for Better Employee Dimension Modeling

The employee dimension presents one of the trickier challenges in data warehouse modeling. These five approaches ease the complication of designing and maintaining a 'Reports To' hierarchy for ever-changing reporting relationships and organizational structures.  Read more...
By Additional Articles 2009/08/26 | Source: SQLServerCentral.com | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 2,989 reads

Introduction to Fast Track Data Warehouse Architectures

This paper provides an overview and guide to SQL Server® Fast Track Data Warehouse, a new set of reference architectures created for scale-up (SMP) SQL Server based data warehouse solutions. It includes a summary of the resources available in the reference configuration, the distinguishing features of the approach, and the steps necessary to take full advantage of the new architectures.  Read more...
By Additional Articles 2009/06/26 | Source: TechNet Blogs | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 3,374 reads

The Wide-Ranging Effects of MDM on BI Systems

When an enterprise first encounters master data management, it often doesn’t have a clear understanding of how MDM will affect the architecture of its business transaction systems or business intelligence systems. This article describes master data patterns in legacy system architectures, a general MDM architecture and some ways the new MDM layer affects the master data patterns in the legacy layers.  Read more...
By Additional Articles 2009/06/19 | Source: Intelligent Enterprise | Category: mdm
Rating: (not yet rated)  Rate this |   Briefcase | 2,042 reads

Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation

This document describes common data warehouse implementation strategies and proposes an effective hub-and-spoke architecture using a massively parallel processing system with multiple instances of SQL Server databases.   Read more...
By Additional Articles 2009/06/17 | Source: TechNet Blogs | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 1,681 reads

Using SQL Server to Build a Hub-and-Spoke Enterprise Data Warehouse Architecture

Scalable, cost-effective EDW implementation is an elusive goal for many large organizations. Three common approaches include centralized EDW the “monolithic” approach, decentralized collections of data marts, and attempts at hub-and-spoke architectures that combine the previous two. With the acquisition of DATAllegro and the pending release of Project codename “Madison,” Microsoft is poised to deliver a unique and compelling Massively Parallel Processing (MPP) data warehouse solution that combines the best features of both EDW and decentralized data marts.   Read more...
By Additional Articles 2009/05/25 | Source: TechNet Blogs | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 825 reads

SQL 2008 MERGE using Dynamic SQL over a Linked Server

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.   Read more...
By Tommy Bollhofer 2010/05/31 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,349 reads

Book Review: The Data Warehousing Toolkit 2nd Edition

Longtime author and SQL Server guru David Poole takes a look at a classic book about Data Warehousing.  Read more...
By David Poole 2009/04/24 | Source: SQLServerCentral.com | Category: book reviews
Rating: |  Discuss |   Briefcase | 2,052 reads

Kimball University: A Data Warehousing Fitness Program for Lean Times

How can you do more with less? Follow this data warehousing/BI strengthening regimen to cut cost, avoid expenditures and bulk up the bottom line.  Read more...
By Additional Articles 2009/03/24 | Source: Intelligent Enterprise | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 2,439 reads

The Flaws of the Classic Data Warehouse Architecture, Part 1

Visit ten randomly picked customers that own a data warehouse architecture, and you will see that at least eight have developed a classic data warehouse architecture (CDWA). What do I mean by a CDWA? In a CDWA, data is copied periodically from production systems to the central data warehouse.  Read more...
By Additional Articles 2009/03/20 | Source: B-Eye | Category: data warehousing
Rating:  Rate this |   Briefcase | 5,502 reads

Functions for using the keys from the Date and Time Dimensions

Three functions for obtaining the date and time dimension keys with a date or the date from the keys  Read more...
By Joshua A. Walker 2011/05/03 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 4,219 reads

Function to Add Leading 0's (Zeros) to an INT

Very simple function code to add leading zeros to a passed in int for a length also passed.  Read more...
By Joshua A. Walker 2009/03/05 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 1,571 reads

A Cloudy Week - Database Weekly (Mar 2, 2009)

There has been a lot of news about cloud computing this past week, including an announcement about SQL Server.  Read more...
By Steve Jones 2009/03/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 201 reads

Week of Warehousing Webinar Series

Join SQL Server authors and MVPs for a week of warehousing and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning you won't want to miss out on this free "week of warehousing" webinar series, free from SQLServerCentral.com and in partership with Wrox and Pragmatic Works.  Read more...
By Press Release 2009/02/19 (first published: 2009/01/28) | Source: SQLServerCentral.com | Category: webinar
Rating: |  Discuss |   Briefcase | 8,988 reads

Date and Time dimension creation and population T-SQL

Dim_Date and Dim_Time. Date and Time dimensions. Creation, population with holidays, indexing and use script.  Read more...
By Joshua A. Walker 2013/10/04 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 22,747 reads

Week of Warehousing Webinar Series

Join SQL Server authors and MVPs for a week of warehousing and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning you won't want to miss out on this free "week of warehousing" webinar series, free from SQLServerCentral.com and in partership with Wrox and Pragmatic Works.  Read more...
By Press Release 2009/02/19 (first published: 2009/01/28) | Source: SQLServerCentral.com | Category: webinar
Rating: |  Discuss |   Briefcase | 8,988 reads

Week of Warehousing Webinar Series

Join SQL Server authors and MVPs for a week of warehousing and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning you won't want to miss out on this free "week of warehousing" webinar series, free from SQLServerCentral.com and in partership with Wrox and Pragmatic Works.  Read more...
By Press Release 2009/02/19 (first published: 2009/01/28) | Source: SQLServerCentral.com | Category: webinar
Rating: |  Discuss |   Briefcase | 8,988 reads

Week of Warehousing Webinar Series

Join SQL Server authors and MVPs for a week of warehousing and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning you won't want to miss out on this free "week of warehousing" webinar series, free from SQLServerCentral.com and in partership with Wrox and Pragmatic Works.  Read more...
By Press Release 2009/02/19 (first published: 2009/01/28) | Source: SQLServerCentral.com | Category: webinar
Rating: |  Discuss |   Briefcase | 8,988 reads

Week of Warehousing Webinar Series

Join SQL Server authors and MVPs for a week of warehousing and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning you won't want to miss out on this free "week of warehousing" webinar series, free from SQLServerCentral.com and in partership with Wrox and Pragmatic Works.  Read more...
By Press Release 2009/02/19 (first published: 2009/01/28) | Source: SQLServerCentral.com | Category: webinar
Rating: |  Discuss |   Briefcase | 8,988 reads
<< Newer    Items 41 to 60 of 317    Older >>
 
Tags
miscellaneous (69)    
analysis services (ssas) (62)    
design and theory (58)    
maintenance and management (29)    
t-sql (29)    
sqlinsider scripts (12)    
olap server (11)    
data mining (10)    
sql server 2008 (10)    
etl (7)    
sql server 7 (7)    
backup / restore (6)    
replication (6)    
indexing (5)    
integration services (ssis) (5)    
programming (5)    
administration (4)    
business intelligence (4)    
extract, transform, load (etl) (4)    
mdx (4)    
news (4)    
database design (3)    
lock and connection management (3)    
mail (3)    
reporting services (ssrs) (3)    
scalability (3)    
sql server 2005 (3)    
best practices (2)    
blogs (2)    
code generation (2)    
data profiling (2)    
datawarehouse (2)    
datetime (2)    
development (2)    
dimensions (2)    
dts (2)    
editorial (2)    
interviews (2)    
mdm (2)    
merge (2)    
online (2)    
partition (2)    
partitioning (2)    
performance tuning (2)    
slowly changing dimensions (2)    
sql server (2)    
webinar (2)    
ado (1)    
advanced (1)    
advanced querying (1)    
basics (1)    
biml (1)    
book reviews (1)    
capacity planning (1)    
change data capture (cdc) (1)    
cloud services (1)    
columnstore index (1)    
data (1)    
data compression (1)    
data mart (1)    
data vault (1)    
database weekly (1)    
dba (1)    
defragmentation (1)    
dimensional modeling (1)    
employee dimension (1)    
events (1)    
fast track data warehouse (1)    
hashbytes (1)    
master data services (mds) (1)    
mpp (1)    
multi-tenant (1)    
parallel (1)    
populate (1)    
product reviews (1)    
rebuild (1)    
reviews (1)    
sql server 2008 r2 (1)    
star join (1)    
star schemas (1)    
strategies (1)    
try..catch (1)    
very large table (1)    
visual basic 6 (1)    
warehouse (1)