This site has different types of readers. Those that come here to quickly look up something, using it as the reference this is. And those that read everything, or at least the pages they consider interesting, using it as a source of knowledge in addition to books, blogs, conferences, etc.
Especially the second type of reader might want to know when something changed. That’s what this page is for. Here you will find a full log of all changes. Most recent first.
November 18, 2018
- Index Spool: New page with the description of the Index Spool operator.
- Added link to the Index Spool page on the Operator list page (and a few other pages).
- Table Spool: Correction to the “Order-preserving” property. Also fixed a few typos.
- Added or corrected links to other pages on several pages.
November 15, 2018
- Table Spool: Small correction to the flowchart in the “Actual Logic” section.
November 13, 2018
- Table Spool: Corrected the links for the “operator properties” and “implicit properties” tables (thanks, Jan!).
November 11, 2018
- Updated the Common properties and Plan properties pages with properties found in the last Cumulative Update of SQL Server. (SQL Server 2017, CU12). Some of these are new, others I had originally overlooked.
November 7, 2018
- Table Spool: New page with the description of the Table Spool operator.
- Added link to the Table Spool page on the Operator list page (and a few other pages).
October 27, 2018
Changed the RSS feed to include all pages on this site instead of only the blog posts.
September 24, 2018
- Operator list: Replaced all SQL Operations Studio operator icons with the (slightly changed) operator icons as displayed in Azure Data Studio.
- Assert, Hash Match, Merge Join, Nested Loops, Segment, Stream Aggregate: Replaced SQL Operations Studio operator icon with the Azure Data Studio version.
September 10, 2018
- Home page: Replaced link to Grant Fritchey’s execution plans book to reference the third edition.
July 30, 2018
- Assert: New page with the description of the Assert operator.
June 27, 2018
- Segment: New page with the description of the Segment operator.
- Added link to the Segment page on various other pages.
June 4, 2018
- Plan properties: Formerly a section on the generic information page, now a page of its own.
- Generic information: Split off the section on plan properties to its own page.
- Homepage: Added link to plan properties.
- Added menu with direct access to relevant pages (thanks, Joshua!)
June 2, 2018
- Generic information: Fixed a copy/paste error (thanks, Richard!); added additional information to plan property RetrievedFromCache; added plan properties StatementParameterizationType and StatementSqlHandle.
- Homepage: Added link to change log.
May 31, 2018
- Generic pages: Homepage, Common properties, Generic information, Operator list.
- Operator pages: Hash Match, Merge Join, Nested Loops, Stream Aggregate.
- Background pages: Logical join operations.