Hm, no takers? OK, let me rephrase:

If you use a booking/reservation/scheduling system for your various internal projects to use your limited supply of test servers (this would be my preferred...

Ah, OK I see where you are coming from.

The problem that I was getting at is not so much the lack of integrity in the deltas so much as the...

Sorry, I'm not following. From the way you've described it, I'm thinking that either:

1) a step is missing, or

2) the data mart is a complete truncate/reload, not incremental.

Why I think...

Yep, that is what is being done.

Source (T1, T2) > staging (still in shape of source, ie, T1s, T2s) > transformation > denormalized warehouse. It's at the transformation > warehouse...

The attributes of a relation have no inherent order, because they are elements of a set (the set of attributes defining the relation), and sets have no order.

Right, now that...

Thanks for helping me think this one through Gail. I have a hypothesis I need to test, but it seems to me like it makes a lot of sense.

Given:

1) The...

Something else that just hit me: Why would SQL server be using the @0=@1 paramaterized plan for the execution of the "where hire_no = <value>" query? That doesn't make sense....

Indeed... that's where I got the plan from: cached_plans...

Thanks muchly, I'll take a look.

I guess what I'm hoping for in replies is some ideas for "next steps". I know SQL pretty well... but for the true experts out...

Oh and thanks for the link. Registering now.

Edit: Can't seem to find that particular presentation. It wasn't #18 I hope...

Tangent on PASS: While I was in Canada for a...

I'm aware that in SQL there's no paramaterization of the column name from SQL's point of view, but it seems the client app is doing some kind of strange hybrid...

SQL Server configuration manager gives me headaches every week. It seems to be the most unstable part of the product (I have to end the process on a semi-regular basis...

In the MCTS book on SQL 2005 BI, there is a paragraph on when SSIS can and cannot actually perform a fast load (bulk insert) style operation, even when the...

That looks right to me as well from what I've gathered.

You've identified parts and processes as nouns in your description which, as a general rule, makes them likely candidates...

If you think keeping things partitioned is a good idea for performance reasons, you should look into table partitioning rather than using multiple tables. Having said that, making sure your...