Viewing 15 posts - 15,676 through 15,690 (of 22,211 total)
Steve Jones - Editor (3/16/2010)
I have had some authors that we have gone through 5 or 6 drafts to get a barely understandable article.
And I've apologized for that over &...
March 16, 2010 at 10:30 am
I'm not aware of a precise method for calculating your number, but if I wanted to make an educated guess, I'd query the procedures that are currently in cache to...
March 16, 2010 at 10:29 am
Lynn Pettis (3/16/2010)
Grant Fritchey (3/16/2010)
March 16, 2010 at 10:24 am
ESAT ERKEC (3/16/2010)
I think you can look at the query parralesim parameter in the server.
Which one specifically?
March 16, 2010 at 10:24 am
malachyrafferty (3/16/2010)
currently the cost threshold is set at 5 - i have no idea what that...
March 16, 2010 at 9:18 am
CirquedeSQLeil (3/16/2010)
Grant Fritchey (3/16/2010)
CirquedeSQLeil (3/15/2010)
george sibbald (3/15/2010)
Always...
March 16, 2010 at 9:12 am
Steve Jones - Editor (3/16/2010)
Actually we're not. We try to get a wide variety of opinions and styles. Happy to get some people writing from the...
March 16, 2010 at 8:54 am
malachyrafferty (3/16/2010)
CXPACKET 3344303.7276.4476.44
PAGEIOLATCH_SH 407470.349.3185.76
LCK_M_SCH_M 173911.163.9889.73
ASYNC_NETWORK_IO 118890.632.7292.45
BROKER_TASK_STOP 93700.662.1494.59
LCK_M_S91672.272.10 96.69...
March 16, 2010 at 8:48 am
Paul White (3/16/2010)
Grant Fritchey (3/16/2010)
Yeah, it was absolutely top notch. Too bad he didn't write it for the Standard. I would have paid more. 😀
$500!!!
But, you must:
Have 5 years professional...
March 16, 2010 at 8:36 am
It's all based on the estimated costs of the query as determined by the optimizer. If that estimate is higher than the cost threshold for parallelism, then you have the...
March 16, 2010 at 8:32 am
Yep, that's it. It's a DMV to give you a view into what things are waiting for what in the server. You'll need to look in BOL or online at...
March 16, 2010 at 8:28 am
There's still not enough information to see exactly what the cause of slow performance might be. I'd suggest you gather data using sys.dm_os_wait_stats. Get that information together over a period...
March 16, 2010 at 7:24 am
sp_executesql is actually one of the best ways to run ad hoc tsql because you can parameterize it and get more plan reuse.
It sounds like, possibly, you're hitting a parameter...
March 16, 2010 at 7:00 am
It's possible that it's a memory issue. What other metrics have you gathered? Do you have wait statistics available? That will tell you what things are waiting on, which is...
March 16, 2010 at 6:58 am
What about a simple backup and restore? Or are you trying to build some sort of deployment mechanism?
March 16, 2010 at 6:50 am
Viewing 15 posts - 15,676 through 15,690 (of 22,211 total)