Viewing 15 posts - 256 through 270 (of 274 total)
Please help on how to resolve the issue
August 2, 2015 at 9:19 am
Thanks for the reply. I had attached the execution plan in my previous post.
July 31, 2015 at 1:01 pm
Thanks a million Jacob for the crystal clear explanation.
July 30, 2015 at 11:16 pm
Dear Gail Shaw,
Could you please let me know the script that dentifies the queries which are doing parallel scans.
July 30, 2015 at 2:22 pm
Thanks for the reply sir. I googled on how to identify queries which are doing parallel scans but did not find. Could you please let me know how to identify...
July 30, 2015 at 4:15 am
Thanks for the reply sir. I googled on how to identify queries which are doing parallel scans but did not find. Could you please let me know how to identify...
July 29, 2015 at 5:18 am
Dear Alex,
Google gave several links. I went through the links. Some are saying to change MAXDOP from 0 to 1. However,Paul Randall's blog is saying not to change MAXDOP. As...
July 29, 2015 at 4:20 am
Thanks for replying. There is also this "ACCESS_METHODS_SCAN_RANGE_GENERATOR" from the screenshot.Could you please let me know how to deal with these kind of issues and how to resolve these issues.
July 27, 2015 at 10:55 pm
Thanks for the reply. My doubt is that why did it timeout only on that day and not on the other days?
July 27, 2015 at 12:25 pm
Hi Alex,
Here is the type of column PickUpTime:
PickUpTime(udt_Date(datetime),not null)
udt_Date is user defined type and here is its definition:
CREATE TYPE [dbo].[udt_Date] FROM [datetime] NOT NULL
tblBidMaster table size is 84.5 MB and...
July 27, 2015 at 2:14 am
Hi Alex,
Here is the type of column PickUpTime:
PickUpTime(udt_Date(datetime),not null)
udt_Date is user defined type and here is its definition:
CREATE TYPE [dbo].[udt_Date] FROM [datetime] NOT NULL
tblBidMaster table size is 84.5 MB and...
July 26, 2015 at 10:40 am
Thanks for the reply. My doubt is that why did it timeout only on that day and not on the other days?
July 26, 2015 at 6:47 am
Thanks a lot for replying. Actually, the stored proc calls another stored proc and hence there are 2 execution plans.Could you please advise on how to improve this proc.
July 24, 2015 at 9:07 am
I manurally ran it. Please find the execution plans attached. I am an entry level junior dba and I request your valuable advise.
July 24, 2015 at 5:57 am
Do i need to run the stored procedure now to view the execution plan? It is in production and I cannot run the stored proc now. How can i get...
July 24, 2015 at 5:20 am
Viewing 15 posts - 256 through 270 (of 274 total)