:w00t:

Thanks!

I was beating my head against the wall based on the display of the execution plan and both made 4 reads despite how the plan was displayed! Below is a...

each table has an index on the source, and a constraint limiting the range a source can be in.

as an example: table [A] can have sources 1-10 table ...

I just ran into this and it was a permissions error.

right click on db & log files Properties->Security

I had to add in the sql server instance user account to have...