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.
Following the recent release of SQL Server 2012 Service Pack 2 and SQL Server 2014 Cumulative Update #3, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a first look at a new performance enhancement and trace flag (2453) aimed at improving cardinality estimates for table variables and table-valued parameters.
Aaron Bertrand (@AaronBertrand) investigates a case where two different methods of deriving an inline constant can lead to very different cardinality estimates.
Aaron Bertrand (@AaronBertrand) discusses several aspects of DBCC CHECKDB and offers suggestions to minimize the impact this crucial operation can have.