shawn swanson

19 reputation

	19 reputation	bio	website		visits	member for	5 months
3 badges		location			seen	Dec 19 '12 at 19:32

13 Actions

Dec 14	awarded	Commentator
Dec 14	comment	Select blocking issue I am willing to avoid same situation. If I can use lock timeout then there will be no blocking. I guess!!
Dec 14	comment	Select blocking issue @Mark Storey-Smith It worked for few hours but again issue raised. Perhaps, locks were removed by detaching & attaching
Dec 14	comment	Select blocking issue Is there a way to add timeout for UPDLOCK ??
Dec 14	comment	Select blocking issue Thanks, I will try it & let u know
Dec 14	comment	Select blocking issue Do you think, changing query like this can help fixing issue? Is issue related to query written in different way?
Dec 14	comment	Select blocking issue We have software which scrape info for product like images, data from forum etc. SOftware run 24 hours
Dec 14	awarded	Editor
Dec 14	comment	Select blocking issue Problem has started few days ago, companies has around 3000 records, products has around 60000 & tblcompanydetail has around 240,000 records.
Dec 14	comment	Select blocking issue I have reposted my procedure, I missed on statement before
Dec 14	revised	Select blocking issue added 298 characters in body
Dec 14	asked	Select blocking issue
Dec 13	awarded	Student