Continuing his series on row goals, Paul White explains how they can impact certain types of semi joins, and how you can spot these effects in showplan and trace flag output.
Paul White provides some great information about row goals, explaining why they're important to understand when examining why the query optimizer made a certain choice.
Paul White (@SQL_Kiwi) walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.
For this month's T-SQL Tuesday, Rob Farley takes a look at a couple of unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.
