Welcome to MSDN Blogs Sign in | Join | Help

News

  • Visit the SQL Server Best Practices site (http://sqlcat.com) for real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level.

Browse by Tags

All Tags » SSIS   (RSS)
Assigning surrogate keys to early arriving facts using Integration Services
In data warehouses, it is quite common that fact records arrive with a source system key that has not yet been loaded in the dimension tables. This phenomena is known as “late arriving dimensions” or “early arriving facts” in Kimball terminology. When Read More...
Posted: Wednesday, May 13, 2009 4:26 PM by tkejser | 5 Comments
Filed under: , , , , ,
Ultimate guide to upgrading to SQL Server 2008
For the ultimate guide to upgrading to SQL Server 2008, please refer to the SQL Server 2008 Upgrade Technical Reference Guide . A successful upgrade to SQL Server 2008 should be smooth and trouble-free. To achieve that smooth transition, you must devote Read More...
Posted: Monday, December 08, 2008 12:57 AM by denny.lee | 3 Comments
Filed under: , , ,
SSIS 2008 - world record ETL performance
Using SQL Server 2008 and SSIS 2008 the SQL Server Performance team working with Unisys and SQL CAT have shown SSIS scaling to world record performance! We loaded 1.18 TB in under 30 minutes . You can find more information here: http://blogs.msdn.com/sqlperf/archive/2008/02/27/etl-world-record.aspx Read More...
Posted: Friday, February 29, 2008 9:13 AM by tkejser | 5 Comments
Filed under: , ,
Page view tracker