Viewing 15 posts - 226 through 240 (of 429 total)
Thank you. I will run the update statistics with a full scan and then try changing the code as you suggested a while earlier and then will post the code...
August 24, 2011 at 12:16 pm
weitzera (8/24/2011)
August 24, 2011 at 11:38 am
Here is the plan. Please let me know if you see anything that can be improved at DBA end.
August 24, 2011 at 5:16 am
Nils Gustav Stråbø (8/24/2011)
The reason is the massive WHERE clause which is trying to use short-circuiting, but this usually doesn't work in...
August 24, 2011 at 4:51 am
weitzera (8/23/2011)
August 24, 2011 at 2:33 am
Thank you. I will make the changes tomorrow morning as its 1 am here and i am finding it hard to concentrate now. Will post the plan as soon as...
August 23, 2011 at 1:29 pm
weitzera (8/23/2011)
You might try changing the...
August 23, 2011 at 12:13 pm
Thanks to both of you. I will learn with the examples you provided and try to implement an inline function.
Meanwhi8le, the function was being used to display 'dispatchstatus'. To...
August 23, 2011 at 8:31 am
The view itself is nasty:
SELECT
b.CarrierCode,b.Descr as CarrierDescr, a.Comment, a.InternalCmt, RTRIM(e.CustName) as CustName, e.CustNum, a.DeliveryDate, Year(a.DeliveryDate) as DeliveryYear, a.InvDate,
a.InvoiceAmt, a.OrderID, a.OrderStatus, a.Po...
August 23, 2011 at 7:20 am
Nils Gustav Stråbø (8/23/2011)
Its probably in the view vw_D1OrderHeader.
Yes. you were faster enough to leave me behind in editing my post. It is indeed the part of the view. What...
August 23, 2011 at 7:05 am
I found the operator from the plan which you talked about. As per your remark, this function is getting executed 85k+ times. Not sure, how to avoid this.
Can you...
August 23, 2011 at 6:58 am
thank you both. I am trying to figure out the compute scalar operator among so many operators, so meanwhile I am attaching the schema for the procedure which I never...
August 23, 2011 at 6:32 am
Nils Gustav Stråbø (8/23/2011)
chandan_jha18 (8/22/2011)
Nils Gustav Stråbø (8/22/2011)
August 23, 2011 at 6:01 am
Nils Gustav Stråbø (8/22/2011)
dbo.fn_GetDispatchStatus
Did it look costly to you? I mean we can write something better here but can we find some way to reduce so much of execution time.
thanks
August 22, 2011 at 1:56 pm
Nils Gustav Stråbø (8/22/2011)
Start by removing the scalar function. Does it run any faster/less reads? If so, try to rewrite the scalar function to a inline table valued function.
Which scalar...
August 22, 2011 at 1:10 pm
Viewing 15 posts - 226 through 240 (of 429 total)