Over the last few days I've learnt a lot in how to debug SQL hangs thanks to Sunil from the SQL Server engine team. For one of the customers last week, the problem seemed to be that their DTS2000 package worked great with SQL2000. However, upgrading...

It's typical in data warehouse loads to have lookups that go against dimension tables. If the key doesn't exist, either a new one is created, or a default value is used. There're two ways to do this: 1. Lookup is configured to redirect rows that...