That sounds reasonale, however, if you look back to one of my earlier posts I explain how there is an example that clearly displays a group being entered as an...

Am I communicating my problem ineffectively or are we all legitimately stumped? Somehow I thought there would be more interest in this topic, since it pertains to enterprise scalability.

Thanks for the reply. That would really defeat my purpose though.

I need a group to be able to be the owner of an agent job.

So imagine there are two...

nobody else has experienced this?

BufferTempStoragePath is only used when SSIS needs to page out, meaning it is low on memory and needs swap space.

It is true that you may be having a permissions issue...

indeed...this query may be optimum...thanks

I've seen the query optimiser make some seriously bad decisions....I don't think this one is soo bad.

...but, the query plan is using a hash-match and needs to be told to...

cool....thanks for the input.

I am having pretty good overall performance with this, just trying to tighten up anything I can.

Just read that if the source table is a considerable amount...

I am actually moving a datawarehouse from 2000 into 2008 with tons of modeling changes.

Here is the syntax for how I am batching the popuation of this particular dimension. I...

good point Gila, I do not know if it is more efficient.

What I was driving at, though, is that the merge syntax doesn't seem to allow index hints on...

Check out Microsoft SQL Server BI Metadata Samples and Toolkit.

I guess I wasn't looking for help with performance tuning on the query. I was looking for any advice on a general approach.

Imagine I have a table with only 2...

for each row in the table

I need to take that 1 row and turn it into 1 row for every month between the effective date and expiration date.

if the 2 series of columns have the same number of occurerences then that would be perfect for an SSIS unpivot task

are yu posotive you want to extract and trannsform your data this way??

Any reason you can't bulk insert and run updates via execute sql task?

That should perform faster