Viewing 15 posts - 2,191 through 2,205 (of 8,416 total)
Brandie Tarvin (2/22/2011)
February 22, 2011 at 9:01 am
Brandie Tarvin (2/18/2011)
And I forgot to try the mouse hover.
You can also click on a plan icon (SELECT in this case) and look in the Properties window (hit F4).
Back to...
February 18, 2011 at 5:53 am
Brandie Tarvin (2/17/2011)
What is the effect of building a non-clustered index over a clustered index?
Exactly as Lutz and Craig said: the non-clustered index is much narrower, so more many more...
February 17, 2011 at 5:49 pm
Brandie Tarvin (2/17/2011)
On your blog, you state:
Impressively, the estimated execution cost for the original query was about 0.007; for the “Segment Top” plan, the estimated cost is about 0.006...
February 17, 2011 at 5:27 pm
Lempster (2/14/2011)
Brilliant and funny article Paul. I wonder if Daniel Vettori really does wear wasabi lip balm?! 😛
He does, and he buys it from Bob :laugh:
February 14, 2011 at 2:28 am
WayneS (1/26/2011)
Well, Joe still has his rhetoric, but it seems to have been toned down quite a bit. Almost an attempt to be humorous about it.
He really seems to be...
January 26, 2011 at 11:40 am
David Portas (1/26/2011)
January 26, 2011 at 8:50 am
kenambrose (1/26/2011)
Yes I can see, based on the approach offered in your article, that you would consider such commitment to Codd's work "zealotry" and dismiss it as entertainment...
No you are...
January 26, 2011 at 8:08 am
kenambrose (1/25/2011)
January 26, 2011 at 1:56 am
I have made a number of small changes to the published text based on comments received so far. Thanks to everyone for their opinions and insights.
January 23, 2011 at 9:34 pm
Ken,
The fact is that the surrogate key + enforced unique natural key idea just would not fit nicely within the flow of the story, while keeping the article to a...
January 22, 2011 at 9:09 am
Thanks everyone for the comments, both here and by email.
At the risk of stating the painfully obvious, of course the design has limitations, and yes in some important respects the...
January 18, 2011 at 5:42 pm
Hey Wayne,
The (./text())[1] modification (and variations) has been around for a very long time. I included in the CSV demo in part 2 of my APPLY article in April...
January 14, 2011 at 11:35 am
Roy Ernest (1/14/2011)
January 14, 2011 at 6:05 am
Just noticed the title of this thread is memROY issues! :laugh:
January 13, 2011 at 5:37 pm
Viewing 15 posts - 2,191 through 2,205 (of 8,416 total)