Viewing 15 posts - 8,356 through 8,370 (of 13,876 total)
NOT EXISTS is generally the more performant, because of the short-circuiting built into that construction.
But you should verify it for yourself by testing and examining execution plans.
June 11, 2015 at 8:45 am
Sioban Krzywicki (6/11/2015)
June 11, 2015 at 7:13 am
vipin_jha123 (6/11/2015)
I have created one variable name migration_start datetime
which give me default format of 6/11/2015 1:26 AM
But I expecting to get in 2015-06-11 01:26:22.813 format.
kindly suggest me the...
June 11, 2015 at 5:06 am
terry_stjean (6/10/2015)
I have the task set to redirect the row if the conversion fails so...
June 11, 2015 at 2:12 am
Are the referenced items part of the branch?
June 11, 2015 at 2:07 am
vipin_jha123 (6/11/2015)
Hi ,I want to see the value of variable in single massage.
I am using C#2012 code
I am able to get using below code in 2 diffrent masg window.
MessageBox.Show(Dts.Variables["migration_start"].Value.ToString());
MessageBox.Show(Dts.Variables["LastRunDate"].Value.ToString());
Regards,
Vipin Jha
Something...
June 11, 2015 at 1:14 am
Phillip.Putzback (6/9/2015)
June 10, 2015 at 12:38 am
Paul Sims-405749 (6/9/2015)
June 10, 2015 at 12:33 am
luis_carlosh (6/10/2015)
The query uses a normal select , and milliseconds are the result of repetitive executions .In relation to the implementation plans and disk settings , I must review.
Execution plan,...
June 10, 2015 at 12:29 am
When you performed the migration of the database to 2014, what steps did you take?
June 9, 2015 at 11:20 am
mbrady5 (6/8/2015)
Thanks Phil,I was just responding with that. I was wondering if anyone had thoughts with regard to the best method using SSIS.
I'm not sure what a 'shared location filer'...
June 9, 2015 at 12:48 am
Was your question about whether to use SSIS or not? Or was it about which technique to use within SSIS?
June 8, 2015 at 12:03 pm
You could try the import wizard.
June 6, 2015 at 3:08 am
Oh yes it helps, very nice. Thank you very much!
June 5, 2015 at 6:58 am
Junglee_George (6/4/2015)
Actually my need is to rearrange the JOINs and ON conditions in a meaningful readable way.
There are so many JOINs written in a very...
June 4, 2015 at 1:19 am
Viewing 15 posts - 8,356 through 8,370 (of 13,876 total)