SQLAuthority News – Fast Track Data Warehouse 3.0 Reference Guide


I am very excited that Fast Track Data Warehouse 3.0 reference guide has been announced. As a consultant I have always enjoyed working with Fast Track Data Warehouse project as it truly expresses the potential of the SQL Server Engine. Here is few details of the enhancement of the Fast Track Data Warehouse 3.0 reference architecture.

FastTrackDw SQLAuthority News   Fast Track Data Warehouse 3.0 Reference Guide

The SQL Server Fast Track Data Warehouse initiative provides a basic methodology and concrete examples for the deployment of balanced hardware and database configuration for a data warehousing workload. Balance is measured across the key components of a SQL Server installation; storage, server, application settings, and configuration settings for each component are evaluated.

Description Note
FTDW 3.0 Architecture Basic component architecture for FT 3.0 based systems.
New Memory Guidelines Minimum and maximum tested memory configurations by server socket count.
Additional Startup Options Notes for T-834 and setting for Lock Pages in Memory.
Storage Configuration RAID1+0 now standard (RAID1 was used in FT 2.0).
Evaluating Fragmentation Query provided for evaluating logical fragmentation.
Loading Data Additional options for CI table loads.
MCR Additional detail and explanation of FTDW MCR Rating.

Read white paper on fast track data warehousing.

Reference: Pinal Dave (http://blog.SQLAuthority.com)


5 thoughts on “SQLAuthority News – Fast Track Data Warehouse 3.0 Reference Guide

  1. Hi I am facing a problem with Address Block. How to separate the Address block using Sql server.

    402 EDGEWOOD New York, ND 58282

    After separation it would be like this.

    AddressLine1 City State ZIP
    402 EDGEWOOD New York ND 58282

    This is a sample output. every time i used to work on thousands of records with differant addresses. I m getting state and zip. but not the city.

    Any help appriciated, Thanks in Advance.


  2. For businesses in Australia, MIP is Microsoft Gold Partner for Business Intelligence and we specialise in Agile data warehouse delivery using Fast Track Data Warehouse 3.0, and we can build your solution using WhereScape RED for even faster delivery.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s