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
One thing that I don't quite understand...
The last query in your article
November 10, 2012 at 7:03 pm
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
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
try to install SQL Server 2005 sp3 or sp4 may solve this problem..
May 31, 2011 at 9:04 pm
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
Viewing 6 posts - 1 through 6 (of 6 total)