Kevin Kline (@kekline) provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of trace flags.
Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.
For this month's T-SQL Tuesday, Rob Farley looks at some unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.
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.
Paul White (@SQL_Kiwi) shows how an update may fail when a partition has some data on a read-only filegroup, and explains several workarounds.
Paul White (@SQL_Kiwi) goes into detail about another reason you'll want to use the
NOEXPAND hint, even when using Enterprise Edition.
The SQL Server plan cache is one of the most important architectural elements for DBAs to understand. Get the slide deck and sample scripts here.
SQL Server MVP Matan Yungman shows ways to identify specific query bottlenecks while the query is running, mostly using native tools in SQL Server.