...No responses at all....!!!

Please help...I just want to let one of my user to see and execute a prticular job manually...

Please guide...

Thanks.

edited - posted in wrong place.

Kindly let us know if you could find the exact cause of the issue and how could you solve it. It will be helpfull to others including myself.

...I too got it right..

Am sure, it's a just a typo..

Yes..Will do that.

I just took on this server and this issue.

Thought memory tables would be faster, hence used it.

Thank you.

Is there any job running which truncates and shrink the log..? Please confirm.

Thanks a lot.

haaaa...I lamost did it with a temp table and some joins.

tried with test data and performance is much better.

but have a doubt on left outer join.

I want to insert data...

Thanks for the clarification.

Infact I was under the wrong impression.

Wel, I will check the procedure again.

Requirement is that, we need to loop through each record and check for a particular...

Thanks,

At present only 4GB is allocated. Sometimes application runs very very slow.

Thanks you all.

Inorder to use OPENQUERY option, do we need to create the linked server using MSDAORA provider.?

Right now we are using OLEDB provider.

Thanks.

Thanks for the clarification.

Just one more doubt,

Long back I had read that, Initialy it will allocate single pages till it reached 8 pages. After that it will allocate only extents.

Is...

So ultimately, execution speed will be equal for both the queries....

Good question..I was confused with ans. 1 & 3, went for a toss and lost it. I give too many wrong answeres now a days..Need to be thorough with wot...

.....has got 585 points in this forum.... 🙂