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

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

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.

I manurally ran it. Please find the execution plans attached. I am an entry level junior dba and I request your valuable advise.

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

Thanks a lot for your reply. Actually, there was blocking, self-blocking. I am still not able to understand why the response was very slow only yesterday and not in the...

Thanks for the reply

i checked the mirroring state before issuing the failover command. It was showing "SYNCHRONIZED". But when i issue the failover command, i am getting an error tha says mirror is...

Thanks a lot for replying. Take CAre