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

Content with tags SQL Server 2008, Data Warehousing Rss

   Items 1 to 11 of 11   
 

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,372 reads

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,847 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,557 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,404 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,693 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 | 838 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,372 reads

SQL Server 2008 and Data Compression

One of the more exciting new features in SQL Server 2008 is data compression and Nicholas Cain talks a bit about how this works and how to determine if it fits in your environment.  Read more...
By Nicholas Cain 2009/01/07 | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 9,333 reads

Scaling Up Your Data Warehouse with SQL Server 2008

This paper discusses how to use SQL Server 2008 to get great performance as your data warehouse scales up. We present lessons learned during extensive internal data warehouse testing on a 64-core HP Integrity Superdome during the development of the SQL Server 2008 release, and via production experience with large-scale SQL Server customers.  Read more...
By Additional Articles 2008/11/14 | Source: TechNet Blogs | Category: scalability
Rating: (not yet rated)  Rate this |   Briefcase | 2,267 reads

CDC and Data Warehouse

The following article shows how Change Data Capture can be used to capture incremental data changes and use them in an ETL Process  Read more...
By Additional Articles 2008/11/10 | Source: SQL Server Performance | Category: data warehousing
Rating:  Rate this |   Briefcase | 3,345 reads

Best Practices for Data Warehousing with SQL Server 2008

There is considerable evidence that successful data warehousing projects often produce a very high return on investment. Over the years a great deal of information has been collected about the factors that lead to a successful implementation versus an unsuccessful one. These are encapsulated here into a set of best practices, which are presented with particular reference to the features in SQL Server 2008.  Read more...
By Additional Articles 2008/09/12 | Source: TechNet Blogs | Category: best practices
Rating:  Rate this |   Briefcase | 4,662 reads
   Items 1 to 11 of 11   
 
Tags
t-sql (2)    
best practices (1)    
change data capture (cdc) (1)    
data compression (1)    
extract, transform, load (etl) (1)    
fast track data warehouse (1)    
merge (1)    
performance tuning (1)    
scalability (1)    
star schemas (1)