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.
The next release of Microsoft SQL Server, announced as SQL Server 2017, is available for download in CTP2 at http://tinyurl.com/SQLvNextLinux and offers many cool new features. One set of features that I really want to focus on is adaptive query processing. These new features speed processing of workloads, especially those that have historically been the […]
Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.
As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS). While SSMS is an outstanding administration and T-SQL programming tool, it does have its minor qualms and quibbles. Learn more about all of […]
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.