Viewing 15 posts - 1 through 15 (of 35 total)
Apology for being late in getting back. You were quite correct. Getting rid of the HOLDLOCK solve the issue, however, teh DEADLOCK took other SPs as preferred partner. 🙂
I did...
August 16, 2013 at 7:03 am
Thanks a lot for your insight. We also believed in the same way, specifically, the victim's request on the resource was for an update lock.
We were and still are a...
August 13, 2013 at 11:17 pm
Any word of wisdom regarding the issue please? I really do not believe, the certificate produced by SQL Server has much to play here.
Any highlight on the possible root...
June 24, 2013 at 4:29 am
Any words of wisdom on this please?
Regards
August 25, 2011 at 12:11 am
A little update. I created the proxy on my domain credential which was not included in the local administrator group. Adding the same in that privileged category did make the...
August 24, 2011 at 2:22 am
Thanks so much Pankush.
I am still not very clear with the last scenario, transaction steps, once recorded in the transaction log, will surely be considered while Analysis/roll forward/Roll Backward phase...
August 20, 2010 at 3:13 am
Thanks Ron,
Will go through and update.
Regards.
August 19, 2010 at 2:06 pm
Thanks for the guidance. I have done most of those on a test scenario .. but unless put into a real life scenario, I am not tested properly..:-)
Regards
February 18, 2010 at 8:24 am
Thanks Gail, I've seen your replies and comments in other posts, and I do really appreciate.
Regards.
February 17, 2010 at 12:56 pm
Thank you so much. I appreciate your views...and solely believe being honest is the best stepping stone to start on.
Regards
February 17, 2010 at 12:50 pm
Thanks, I got confused with the co-related subquery.
Regards.
January 7, 2010 at 8:28 am
Thank you so much,
The second query works like a breeze.......However, still I want to know where I was going wrong please.
Regards,
January 7, 2010 at 7:58 am
Thanks for all your valuable advices..... Apology, am a bit late in getting back...(it was night at this part of globe....), I will try as suggested and update at the...
April 30, 2009 at 1:27 am
Hi,
Using ISNULL seems to address the problem but the same absorbes more than an hour....
I was more interested to know what is the root cause of such behaviour, Any...
April 29, 2009 at 7:23 am
Thanks for such quick response ! I tried to use the ISNULL function, but did not continue as it was taking too long....I will have a try and update.
...And...
April 29, 2009 at 5:39 am
Viewing 15 posts - 1 through 15 (of 35 total)