While I am far from an expert in SSIS Performance, my experience has been that a package's performance is very sensitive to the batching and other settings on the dataflow...

michaelJon (2/17/2010)

---

Does this not create a new opportunity for some sort of “marketplace” to be setup where businesses can sell their old licenses to others looking for previous editions, and...

I'll at least give him credit for being smart enough not to post them all in one big list.

Who do that Urdu that they do down in ... well, ... wherever they do Urdu? 🙂

Fazalul Haque (2/17/2010)

---

I assume, after truncating the stage tables you are refilling them in one shot. In that case there will be performance gain in scenario 2.

Two reasons:

1. Indexes...

I think that it depends on a number of different things, starting with exactly how the tables are re-filled. In any event, it's always best to test it to...

Quite.

David Portas (2/17/2010)

---

Just to set the record straight, to the best of my knowledge Chris Date never edited or had control of content at DBDEBUNK. The article and quotation posted...

Paul White (2/16/2010)

---

This strikes me as very funny - but I'm not sure why. Am I missing a reference,...

Fine with me.

I have no intention of slogging through all of the slime on DBDebunk.com, but let me give one tiny, benign (well, compared to other stuff there) example:

This is one of...

David Portas (2/16/2010)

---

RBarryYoung (2/16/2010)

---

I said that the rift was pointless, and it is. Either SQL and Relational Databases are different things or they are not. But 30 years...

Putting predicates for an outer-joined table in the WHERE clause will make it effectively inner-joined.

David Portas (2/16/2010)

---

RBarryYoung (2/16/2010)

---

There's being open-mined and there's being stupid. As a matter of fact I have read Chris Date's work. I have yet to find anything relevant,...

David Portas (2/16/2010)

---

RBarryYoung (2/16/2010)

---

though SQL was based on Relational Theory, they refused to fully adopt the things that Codd wanted them too, which was the original source of the many...