Hi,

I'm sure nobody denies this. But when dealing with inexperienced users or when you need to describe things further than by just providing a strict hour or day measure, you...

I agree, in theory the concept is interesting but in practice, it's well... impractical in my opinion. Simple SSIS lookup operations etc. work really well with dimensions, especially small ones.

I...

The advantage of this method is also that the dimensions are very small (I generate 15 years of days and time, well, by the hour has 24 rows 😉 )

Thank you! Just what I was telling myself while reading this (CTE/Scalability).

Also, when you design a warehouse for a customer that is not necessarily very versed in T-SQL, CTEs...

No worries 🙂

Yes the machine is a brand new SQL 2008 x64 with SP1 and Windows 2008 64 SP1. Mind you I've reproduced it on my 32 bit Vista with...

Hi,

The input parameter is the issue with the sqlncli10.1 provider (the new one for sql 2008). If i use the one from 2005 (sqlncli.1) by manually editing the package's xml...

Sounds good, I'll take a look at those as well thanks.

Regarding the other answers, I'm really looking at something dedicated to monitoring SQL, like a console from which I...

Yes, I agree with the fact that there is information online, but it's scattered all around and can be inconsistent between sources. That's what I want when I buy a...

Hi,

Thanks for all the info, I will check these out. I'm pretty sure there's a fine line between giving enough information for people to make informed decisions and revealing your...

My last piece of info before trying to drop a call at Microsoft...

I was able to narrow down the issue to derived columns and lookups in my data flow transformations....

Alright after more digging it's only happening when my packages are called via the execute package task in the control flow. I can't understand why this would make a difference...

Alright so more info ... When a dev runs the package from his workstation, it's his workstation's lsass that goes up, not the server's, which makes sense. same thing if...

I just disabled all my jobs and my lsass process has gone down dramatically.. This is weird, it looks like some issue with DTEXEC when running the packages as a...

For a couple of them it's a join (custom etl process). But i've talked with the devs and the length can be reduced to a varchar(50), the original size was...

That's what I figured as well but I just wanted to make sure that's what it meant, and not that it depended on some regional/collation setting somewhere that it would...