Did I inspire a Sql Server 2008 feature?
You be the judge:
Go here:
http://blogs.msdn.com/sqlcat/archive/2006/02/17/Partition-Elimination-in-SQL-Server-2005.aspx#5276553
And find this post dated on:
October 4, 2007 1:50 PM
(Note, the post I wrote is above this date stamp)..
Now go here to this URL.
http://technet.microsoft.com/en-us/library/ms345599(SQL.100).aspx
(This article is titled: Query Processing Enhancements on Partitioned Tables and Indexes)
Ok, now the heart of the matter.
Find this line in the technet article:
Partition Summary Information
And read the 3-4 paragraphs below it.
Did I inspire a Sql Server 2008 feature?
You make the call!
Well, I don't care how it got there, but the 2008 version is 100 times better than the 2005 version.
========================================================================
Below are the snipplets that I cite above....But I wanted to give the real URL's so this does not look made up.
http://blogs.msdn.com/sqlcat/archive/2006/02/17/Partition-Elimination-in-SQL-Server-2005.aspx#5276553
October 4, 2007 1:50 PM
Man, what would be nice is something like:
set partitions profile on; --<this does not exist
And then it would just show you:
Table PartitionTouches
t1 1
Because it gets cumbersome/confusing sometimes.
I guess I can dream.
But thank you again for the post...I'd be lost/frustrated without it.
http://technet.microsoft.com/en-us/library/ms345599(SQL.100).aspx
Partition Summary Information
In run-time execution plans, partition summary information provides a count of the partitions accessed and the identity of the actual partitions accessed. You can use this information to verify that the correct partitions are accessed in the query and that all other partitions are eliminated from consideration.
The following information is provided: Actual Partition Count, and Partitions Accessed.
Actual Partition Count is the total number of partitions accessed by the query.
Partitions Accessed, in XML Showplan output, is the partition summary information that appears in the new RuntimePartitionSummary element in RelOp node of the operator in which it is defined. The following example shows the contents of the RuntimePartitionSummary element, indicating that two total partitions are accessed (partitions 2 and 3).
<RunTimePartitionSummary>
<PartitionsAccessed PartitionCount="2" >
<PartitionRange Start="2" End="3" />
</PartitionsAccessed>
</RunTimePartitionSummary>
Tools 
Help
