Viewing 15 posts - 5,521 through 5,535 (of 11,678 total)
Stefan Krzywicki (7/17/2013)
July 17, 2013 at 2:07 pm
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...
July 17, 2013 at 2:03 pm
Grant Fritchey (7/17/2013)
July 17, 2013 at 5:34 am
Here's a fairly complete article on how to concatenate row values using different solutions:
July 17, 2013 at 5:21 am
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.
July 17, 2013 at 5:19 am
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...
July 17, 2013 at 3:27 am
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
July 17, 2013 at 3:24 am
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
July 17, 2013 at 3:24 am
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
July 17, 2013 at 3:24 am
Andy Leonard (7/16/2013)
Comments posted to this topic are about the item <A HREF="/articles/BIML/100552/">What is Biml? - Level 1</A>
Very much looking forward to the rest of the series Andy.
July 17, 2013 at 2:52 am
vijay.hire (7/16/2013)
Where to find BIML and how to install BIML? 🙂
You need to install BIDSHelper from Codeplex.
July 17, 2013 at 2:52 am
Jeff Moden (7/16/2013)
Steve Jones - SSC Editor (7/16/2013)
Arrgggg, some days I hate software.BWAAA-HAAA!!!! You mean like the stuff that generates the SSC News Letter? :sick::-D:-P
Touché 😀
July 17, 2013 at 2:08 am
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.
July 17, 2013 at 1:47 am
kapil_kk (7/17/2013)
GilaMonster (7/16/2013)
Or you could just remove the nolock hints entirely and remove any chance of their nasty side effects causing you problems.See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
Gail,
Can you please tell me that...
July 17, 2013 at 1:45 am
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...
July 17, 2013 at 1:37 am
Viewing 15 posts - 5,521 through 5,535 (of 11,678 total)