Viewing 15 posts - 271 through 285 (of 1,825 total)
CXPACKET waits are down to parralelism. You could try using maxdop 1 to negate that , but IMO its probably a symptom and not the cause.
Please post plans ,...
April 13, 2011 at 4:44 am
David Burrows (4/7/2011)
Dave Ballantyne (4/6/2011)
Any other threadzian going to be at sqlbits ?Yarp, Saturday.
Good to meet you on saturday, it was a fun weekend 🙂
April 12, 2011 at 8:59 am
C.K.Shaiju (4/12/2011)
Hi Dave, The link is exactly what we were looking for. Thanks.So, Our solutions are TRICKS 😀 your link is REALITY :cool:.
Good stuff , but i cant take...
April 12, 2011 at 7:24 am
Please see this link
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
April 12, 2011 at 6:11 am
David Burrows (4/7/2011)
Dave Ballantyne (4/6/2011)
Any other threadzian going to be at sqlbits ?Yarp, Saturday.
Ill make a point to look out for you.
April 7, 2011 at 6:52 am
Any other threadzian going to be at sqlbits ?
April 6, 2011 at 2:35 pm
There is no built in function.
Try this article to get you going though..
April 2, 2011 at 1:29 am
CirquedeSQLeil (3/31/2011)
I have been meaning to do some performance testing on the whole select * thing. I ran into some cases where select * actually beat the pants off...
April 1, 2011 at 12:06 am
tfifield (3/29/2011)
Dave Ballantyne (3/27/2011)
As you...
March 29, 2011 at 1:37 pm
p.stevens76 seems to be quite a serial homework shirker..
Amost (a-lot) of others
http://www.sqlservercentral.com/Forums/Topic986142-392-1.aspx
http://www.sqlservercentral.com/Forums/Topic1084584-1292-1.aspx
March 27, 2011 at 1:32 pm
Assuming that you have a finite list of ID's used, you can use cross apply with TOP, as demonstrated at the end of this article http://www.sqlservercentral.com/articles/T-SQL/71571/
As you want 400 out...
March 27, 2011 at 12:40 pm
Ok ,i thought that as there is some (X =Something or X= NULL) logic it may be being built dynamically.
The amount of rows returned is not really a relevant point...
March 22, 2011 at 5:30 am
March 22, 2011 at 4:30 am
Take a look at the advice given in this link
See if helps you isolate the problem
March 22, 2011 at 3:25 am
Viewing 15 posts - 271 through 285 (of 1,825 total)