Hi,

the posts help a lot.

I did some testing in our environment and I get about 10% slower performance with TDE enabled. Which is quite okay. 🙂

Thanks for the info...

Hello Jason,

that sounds good...

I don't get it why Microsoft isn't describing the cause of...

sam.dahl (12/15/2011)

---

As I said before, the merge join doesn't hold the entire table in memory unless you are using a fully blocking component (such as a Sort or Aggregation). It...

sam.dahl (12/7/2011)

---

In the case of the Merge Join the component is partially blocking and requires the sources to be sorted so what would happen is the component holds onto the...

Hi,

thank you all, for the provided informations.

I tried to use a lookup, but the lookup returns 1 row only! :crazy:

I don't get it, why Microsoft hasn't provided a DataFlowTask like...

Hi,

well linked server is not possible, because of security restrictions. :crying:

sam.dahl (12/6/2011)

---

Potentially, given that you have a small (I'm assuming) result set and a very large set, I would start...

Thank you very much... 🙂

Thanks,

I will try to get the book.

Thank you very much.

That's what I'm wondering....

After the insert with no Clustered Index I have to create it, doesn't it have to completely write the whole table again to the database to create...

Thank you guys, for the great articles and the information you provided. 🙂

As soon, as I get the...

Wow...

that blog is exactly the answer of my question. :w00t:

Thank you very much for your help....

Regards,