Viewing 15 posts - 2,596 through 2,610 (of 8,416 total)
Gianluca Sartori (9/21/2010)
September 21, 2010 at 3:31 am
Steve Jones - Editor (9/20/2010)
I have to admit...
September 20, 2010 at 10:20 pm
Steve Jones - Editor (9/20/2010)
I'm not sure I want to go to the trouble of finding that many Hawaiian images.
My thinking was that all our avatars would be replaced by...
September 20, 2010 at 12:23 pm
Brandie Tarvin (9/20/2010)
He'll set us all to zero and make himself look like the Answer God!
That's an awesome idea for next April 1.
He should also change all our avatars for...
September 20, 2010 at 12:08 pm
CirquedeSQLeil (9/20/2010)
I don't think anybody can catch steve. Remember - he controls the counts
What ever are you suggesting? :blink:
September 20, 2010 at 12:03 pm
Jeff Moden (9/20/2010)
September 20, 2010 at 12:00 pm
Jeff Moden (9/20/2010)
September 20, 2010 at 11:29 am
Brad Schulz (9/20/2010)
SQL2008 (64-bit):
Tally: 314370ms CPU, 87639ms duration (Note the huge CPU, indicating all 4 processors were working hard)
XML: 1451ms...
September 20, 2010 at 11:23 am
bitbucket-25253 (9/20/2010)
Brad SchulzAttempted to view your plans Microsoft Internet Explorer 7.
I blame this site. In Chrome, I always have to right-click the .sqlplan files, Save As, and then...
September 20, 2010 at 11:16 am
Charles Hottle (9/20/2010)
September 20, 2010 at 11:07 am
rob.symonds (9/20/2010)
Ahh, fair enough, thanks again for clearing that up - I'll stop with the questions now.
Questions are all good, Rob. 😎
September 20, 2010 at 10:54 am
rob.symonds (9/20/2010)
Paul, thanks for the insight into what's going on. So, I guess it's an "it depends" but in your opinion, updating the stats on AW2008 should resolve it?
I...
September 20, 2010 at 10:23 am
rob.symonds (9/20/2010)
Anyone else a little concerned about the 2k8 results for the inline Tally?
The latest scripts and results simply show that the optimizer can generate a poor plan, especially when...
September 20, 2010 at 7:53 am
Jeff Moden (9/20/2010)
Ah... perfect, Paul. It looks like the Tally Table join became a Cartesian Join of sorts. I haven't loaded up 2k8, yet.
It's just a 'performance spool'...
September 20, 2010 at 7:44 am
mazzz (9/20/2010)
I would like to help - is the latest code that Jeff would like us to run in the original post?
My understanding is that Jeff welcomes runs from the...
September 20, 2010 at 5:52 am
Viewing 15 posts - 2,596 through 2,610 (of 8,416 total)