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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy