Just to add a little here, recall that a FACT is just that. It captures something that happened at a point in time. There is really no updating here (unless...

The problem is once you begin something there is this inertia that keeps you from wanting to go back and...

I agree with the prior posts that the Kimball books outline well the approach to creating a data warehouse from the ground up. Be careful with defining the "grain." Some...

I dont exactly have SSIS 2005 handy, though in 2008 if it is not too different ...

Right click the project name in the solution explorer > properties > debugging ?(in...

Strange... I was trying to imagine when and how this could be the case.

Data Marts are usually populated from the DW (Inmon or Data Vault), or form the DW...

You can think of the table depicted here as merely a daily snapshot. It is based on actual records of games played. To consider only the last ten games I...

In SQL SERVER 2008 and above you have the MERGE statement. Unfortunately that does not apply to your version of SQL SERVER. For this you should stick with the three...

I got to wonder why create the temp tables to then only pass through a subset of those. Maybe the base tables lacks an index but I dont see the...

I imagine you could add a click event watcher to do this in the CODE window within SSRS. I believe in 2012 you may even be able to use C#...

I am wondering about the unique constraint set around the...

Alvin Ramard (7/8/2015)

---

I doubt there's data type changes that would make it hard to move this to SQL2008.

I agree with Sean. I'd focus on getting as much of the logic...

Just to make your code a little cleaner,

DECLARE @T AS TABLE (y INT NOT NULL PRIMARY KEY);

DECLARE @cols AS NVARCHAR(MAX)

,@y AS INT /* not used */

,@sql AS NVARCHAR(MAX);

Note that...

If you are referencing a large dataset through a linked server, especially if used multiple times in a join condition, you are better served with a temp table. Also a...

You mention in your first post " process 500 records." I'd lile to know more what you mean by process.Are you transforming the data in the foreach loop? There is...

...

Oh... and I almost forgot (this one is a brilliant). They have some funky "automated" way of creating their DWs but it means that most dimensions are basically cookie...