http://sqlblog.com/blogs/paul_white/archive/2010/07/28/the-segment-and-sequence-project-iterators.aspxIn my last post I promised to cover the Segment iterator in more detail, so here we go. Segment The Segment iterator partitions rows into groups as they flow through a query plan, checking whether the current row belongs in the same group as the previousenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/paul_white/archive/2010/07/28/the-segment-and-sequence-project-iterators.aspx#27336Tue, 27 Jul 2010 14:36:32 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:27336Page Free Space - Paul White<p>SQL Server 2005 introduced the OVER clause to enable partitioning of rowsets before applying a window</p>