Viewing 15 posts - 16 through 30 (of 32 total)
Would this help?
WAITFOR DELAY '00:00:00.05' -- Wait for 5 ms
And also if there are 6 threads spanning 70k records, will table partitioning be of help?
December 20, 2012 at 10:11 am
Thank you. Also - the plan changes when I use the same batch using sp_ExecuteSql
I see there are no Key Lookups when I run the same query using sp_executesql as...
December 11, 2012 at 3:53 am
The batch is big. Can you let me know how how I can check the performance benefits.
December 10, 2012 at 11:02 pm
Thanks all for your help. I finally managed it using the same query that I had created.
This query was a part of an SSIS package.
We broadly categorized the conditions...
December 6, 2012 at 11:08 pm
Apologies if I wasnt clear. I have been working on it since last night.
Have reached to some point but need help to proceed.
Please find additional rows in this table to...
November 21, 2012 at 7:07 am
Thanks however it may not always be the last one. The subtraction should happen between consecutive ones.
i.e Row 1- Row 2.
If Row 1 - Row 2 =0 then...
November 20, 2012 at 8:29 pm
Thank you - this helps
November 6, 2012 at 9:50 pm
Thats for your time... yes there was a reason to use Access as data manipulation which would be required later would be easier using queries.
I fixed my issue... by revamping...
February 7, 2012 at 4:31 am
Microsoft Office Access 2007 (12.0.6535.5005) SP2 MSO (12.0.6562.5003)
February 2, 2012 at 4:27 pm
Further information on teh above.
1. The query does not have any group by clause.
2. The only manipulation with the memo field is the prefixing with text "Error:" when the description...
February 2, 2012 at 3:31 pm
I have modified the complete code piece.
Now I have made tables in Access with field type Memo for Description column.
The query has been modifed too.
I need to compare descrioptions from...
February 2, 2012 at 3:24 pm
Yes I am usinig DoCmd to import the excel files into tables and to export query results into excel.
The table structure for import is not predefined.
February 2, 2012 at 9:00 am
I am using Excel 2007 and MS Access 2007.
I use DoCmd to import the data from 2Excel files into Access... and then compare the text and use Do Cmd to...
February 1, 2012 at 10:37 pm
Thanks Jeff.. these are not the actual tables. We are getting two resultsets and want a solution thereafter. However, i do get your point. Cant help much at the moment...
April 18, 2011 at 9:08 am
Thanks for the response.
In the current scenario - there is one set of records being populated in multiple related tables. There is only one set of records for a workflow...
November 12, 2010 at 9:34 am