Viewing 6 posts - 1 through 6 (of 6 total)
One thing that I don't quite understand...
The last query in your article,
----------------------------------------------
WITH MPAPlans
AS (SELECT plan_handle
...
November 10, 2012 at 7:16 pm
#1557937
The last query in your article
November 10, 2012 at 7:03 pm
#1557936
please refer
http://support.microsoft.com/kb/224453/
there is a detailed explaination for every kind of waitresrouce.
October 17, 2011 at 12:18 am
#1395142
you can register it with specifying the port number, please refer to http://www.mssqltips.com/tip.asp?tip=1767
June 5, 2011 at 12:14 am
#1334103
try to install SQL Server 2005 sp3 or sp4 may solve this problem..
May 31, 2011 at 9:04 pm
#1332346
I think the reason is that the batched transactions reduce the cost of getting and release locks compare to one transaction per statement...
January 20, 2010 at 10:25 pm
#1106483