Kink of a job in the SQL server agent that runs your SQL. This is async.

I'm missig the CTE/Recursive approaches to solving these issues. While usually not single pass the beat triangular joins

For Running total see: http://shahamishm.blogspot.com/2009/04/how-to-do-running-sum-using-cte-sql.html

For finding previous row ordered by key_nr and trans_date(clustered...

Some comments.

The article talks about unique indexes, but formally they are alternake keys or uniquenss constraints.

Everybody should be aware that there are situations in which surrogate keys fail to keep...

Thats exactly what Codd intended when he invented the relational model. He wanted the database to protect the integrity of the data, and hence created the relational model to mathematically...

A DWH is a different beast altogether and should not be confused with constructing OLTP database models. Your approach is good for a DWH but less apropraite for an OLTP...

Nice topic Solomon.

I have some suggestion on the log growth:

in the sp: you could use select into, or enable minimal logged inserts on SQL server 2008, see http://msdn.microsoft.com/en-us/library/dd425070.aspx to get...

I would say to all posters that complained about the lack of substance:

Take a Hike, Ike 😀

I like the reference, but then I'm also a fan of Paul Simon.

I...