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...

You can also try getting the default value directly from the result of a dataset query. This is a fully dynamic way to get what you want :

SELECTDATEADD(d, -1,

DATEADD(q,DATEPART(q,getdate())-1,CAST(year(getdate()) AS...

Again, it is doing a clustered index scan (also known as a table scan) instead of using the nonclustered index you created on C6 (with no included columns) because the...

Try DBCC OPENTRAN to view any open transaction the machine you are currently connected to.