Aaron Bertrand (@AaronBertrand) follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.
Aaron Bertrand (@AaronBertrand) asks you to vote for and, more importantly, comment on a Connect item aimed at adding MAXDOP controls to statistics updates.
Tim Radney (@tradney) of SQLskills shows us how the Stretch Database feature has evolved from its early CTP beginnings to the RTM version released earlier this month.
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.
Rob Farley (@rob_farley) digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.
Rob Farley (@rob_farley) looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.
Jonathan Kehayias (@SQLPoolBoy) takes a closer look at a new trace flag that allows you to process multiple concurrent statistics updates on the same table.
