sqlsunday.com

T-SQL programming, useful tips and tutorials for the MS SQL Server developer.

Skip to content
  • Newsletter
  • About sqlsunday.com
  • Structured Concepts
    • Master data tool
    • File parser API
  • Slack app
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Links and utilities
Search

window spool

Segment and Sequence Project

2014-12-072014-12-03 / Daniel Hutmacher / Leave a comment

For windowed functions, SQL Server introduces two new operators in the execution plan; Segment and Sequence Project. If you’ve tried looking them up in the documentation, you’ll know that it’s not exactly perfectly obvious how they work. Here’s my stab at clarifying what they actually do.

Continue reading →

Categories

  • By difficulty (175)
    • Advanced (38)
    • Basics (50)
    • Intermediate (89)
  • CLR (1)
  • Off-topic (13)
  • Rant (5)
  • Scripts (19)
  • Series (29)
    • Efficient data (8)
    • Introduction to T-SQL (1)
    • Slowly changing dimensions (5)
    • SQL Server security (15)
  • SQL Server concepts (74)
  • T-SQL (126)
  • Tips (50)
  • Uncategorized (1)
  • Videos (2)

Search for articles

Create a website or blog at WordPress.com