Lowell Sir,

If these info are not found any books, how does the person who answers the question gets to know such things? Just curious to know. Please share the links,...

Dear Jacob Sir,

DO we need change back the isolation level to READ COMMITTED after running the query.Because, in our current production environment, its set to READ COMMITTED

Dear Gail Shaw Sir,

Thanks a lot for your input. Please help on what i need to do fix these latch error messages. I have attached screenshots in my first post.

Thanks a lot for replying Jayant. You said "In your server", actually i did not understand that.

If these info are not found any books, how does the person who answers the question gets to know such things? Just curious to know

Please help on how to resolve the issue

Thanks for the reply. I had attached the execution plan in my previous post.

Thanks a million Jacob for the crystal clear explanation.

Dear Gail Shaw,

Could you please let me know the script that dentifies the queries which are doing parallel scans.

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...

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...

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...

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.

Thanks for the reply. My doubt is that why did it timeout only on that day and not on the other days?

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...