Viewing 5 posts - 1 through 5 (of 5 total)
It's an interesting blog entry though isn't it? Makes you think.
You bet it is!
However, common sense has always told me that an index should provide a fast way of...
February 7, 2010 at 3:37 pm
Paul,
The reference you mentioned explicitly states that when a secondary index is not declared UNIQUE, it contains the values of the clustered key in the key-level pages:
Now you should see...
February 7, 2010 at 4:05 am
Hi Paul.
Please consider the following code, using the sample data from your blog:
WITH RowIDs
AS (
...
February 6, 2010 at 12:46 pm
This shouldn't change the resultset at all since products without versions will be eliminated by the CROSS APPLY, but lets assume anyway that every Product has at least one associated...
February 6, 2010 at 5:12 am
And now, most importantly, here are the execution results I got running these queries on my 50 million row table.
Hi Matt, I just found this discussion in the referrers to...
February 5, 2010 at 6:45 am
Viewing 5 posts - 1 through 5 (of 5 total)