Stefan Krzywicki (7/17/2013)

---

I've been having my own little annoyance with something SQL Server related lately. If you use SSIS to create text files and save it from one server to...

1. If you are already joining on the Unique No column, which is the clustered index, I don't see why partitioning the table on another column would improve performance (if...

Grant Fritchey (7/17/2013)

---

While I haven't been able to test it at all yet, there is supposed to be a radically improved statistics engine within 2014. That could be a compelling...

Here's a fairly complete article on how to concatenate row values using different solutions:

Concatenating Row Values in Transact-SQL[/url]

You cannot write your select statement like that (meaning by concatenating multiple selects in a row).

Either type INSERT ... SELECT convert(int,@phone), convert(decimal(18, 0),@SertiNom), ...

or use the VALUES clause.

If you properly index the tables according to the join predicates, 500000 rows shouldn't be an issue.

On what would you partition the table? On the unique key? That wouldn't make...

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1474405-148-1.aspx

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1474405-148-1.aspx

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1474405-148-1.aspx

Very much looking forward to the rest of the series Andy.

You need to install BIDSHelper from Codeplex.

Touché 😀

Let's start with number 1.

Why a single DFT and a single source?

You need at least 50 sources, and preferably not in one single data flow.

kapil_kk (7/17/2013)

---

Gail,

Can you please tell me that...

1. If everything needs to be in a stored procedure, why ask your question in an SSIS forum?

2. No caps. There's no need to shout.

3. Don't use lakhs. This is...