Optimising Lookups with the Cache Transform (Video)

by Allan Mitchell 14 May 2010 15:40
How to optimise doing the same lookup multiple times. [More]

Making more of SSIS in 2008 (Presentation)

by Allan Mitchell 13 Mar 2008 01:42
Download the slide deck from my Making more of SSIS in 2008 presentation, first presented at the SQLBits II (The SQL) Community Conference. Abstract Integration Services in SQL Server 2008 is Microsoft’s Enterprise Class ETL Tool. In this session I am going to show you how to use it to do so much more than simply taking a table from one database to another. I am going to show you gems like Change Data Capture, Threading models, Fuzzy Logic, Integration with SSAS and SSRS, Lookup transform caching options and what they mean to you. This session is advanced (level 400) session so yo... [More]

Get all from Table A that isn't in Table B

by Guest 1 Sep 2004 14:00
(By Jamie Thomson) A common requirement when building a data warehouse is to be able to get all rows from a staging table where the business key is not in the dimension table. For example, I may want to get all rows from my STG_DATE table where the DateID is not in DIM_DATE.DateID. There are 2 ways to do this in conventional SQL. -- Method #1 INSERT DIM_DATE SELECT s.* FROM STG_DATE s LEFT OUTER JOIN DIM_DATE d ON s.DateID = d.DateID WHERE d.DateID IS NULL -- Method #2 INSERT DIM_DATE SELECT s.* FROM STG_DATE s WHERE D... [More]

RecentComments

Comment RSS