Did I inspire a Sql Server 2008 feature?

 

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

sholliday said:

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>

Advertisements
This entry was posted in Software Development. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s