Viewing 15 posts - 31 through 45 (of 58 total)
Yes that works and was what I was trying to do, thanks hisakimatama. I thought I had tried that with the code I'm working with and was surprised it...
October 1, 2013 at 12:03 pm
Wow, nice one Mark, got it working now.
September 20, 2013 at 9:24 am
Thanks so much for your help Eugene, Chris, Sergiy. I've rewritten the query according to your suggestions and it now runs much more efficiently. I learned a lot...
May 9, 2013 at 7:08 am
Sergiy (5/8/2013)
First of all you need to make sure the Sourcetable (a1, a2,a3,a4,a5) have clustered index on (CompanyIdentifier,FieldIDNumber)
Many thanks for your suggestions Sergiy.
Yes there is a clustered index that includes...
May 9, 2013 at 5:12 am
Eugene Elutin (5/8/2013)JPG is not very good idea for posting query plan. You better save it as XML. You need to post complete query if you want relevant help. Also,...
May 9, 2013 at 4:40 am
Can you post the query with obfuscated table names?
Yes will do after I've rewritten it slightly to factor in the datatype change for the field ID number. When that...
May 8, 2013 at 6:52 am
Unfortunately, I cannot see anything attached. Anyway, JPG is not very good idea for posting query plan. You better save it as XML. You need to post complete query if...
May 8, 2013 at 5:53 am
ChrisM@Work (5/8/2013)
Can you post the actual execution plan as a .sqlplan attachment please? Makes this kind of exercise much easier.
This query was so long-running (over 2 days) that I haven't...
May 8, 2013 at 5:26 am
Thanks for the suggestions Eugene.
First of all your check for a.FieldIDNumber = '1' should better be moved into WHERE clause
Will try, many thanks
Is your FieldIDNumber defined as varchar or int?...
May 8, 2013 at 4:46 am
Okay great, thanks for your help opc.three, I appreciate it.
January 11, 2013 at 4:35 am
Thanks Phil, yes I was using textpad to do that, but was hoping to 'see what SSIS sees' aswell in the data viewer.
I just found out that you can click...
May 14, 2012 at 9:52 am
Gilamonster - yes stopping SSRS and all the other services (eg SQLServer Agent) allowed me to maintain the open connection in the cmd window - thanks so much!
So that solved...
October 24, 2011 at 4:41 am
Okay thanks thanks Gilamonster and Codebyo. Didn't realise that password was hidden by SQLCMD, that is what was happening when I thought it wasn't accepting my keyboard input.
Now however,...
October 24, 2011 at 3:59 am
Okay thanks GilaMonster and Perry, I think I'm getting closer to understanding what you mean. However there's one bit I still don't know how to do, any assistance would...
October 23, 2011 at 11:57 am
Hi GilaMonster,
Many thanks for the advice. I tried to do the following, not sure that I'm doing what you suggested right:
- Start / Run / cmd
- Typed the...
October 22, 2011 at 10:43 am
Viewing 15 posts - 31 through 45 (of 58 total)