Category : Query Plan Analysis - SentryOne Team Blog

Category: Query Plan Analysis

Adaptive Query Processing in SQL Server 2017

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

Paul White : Properly Persisted Computed Columns

Paul White : Properly Persisted Computed Columns

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.

Paul White : UNION ALL Optimization

Paul White : UNION ALL Optimization

Paul White (@SQL_Kiwi) digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL.

SQL Server Optimizer Secrets With Trace Flag 86xx

SQL Server Optimizer Secrets With Trace Flag 86xx

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 : Using DBCC CLONEDATABASE and Query Store for Testing

Erin Stellato : Using DBCC CLONEDATABASE and Query Store for Testing

Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.

SQL Server 2016 – The Cool is in the Tool (SSMS That is)

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

Rob Farley : Plans with SQL Server 2016 Temporal Tables

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 : Actual Rows Read Warnings in Plan Explorer

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.

Performance Surprises and Assumptions : DATEADD()

Aaron Bertrand (@AaronBertrand) explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.

Paul White : Changes to a Writable Partition May Fail Unexpectedly

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.

SQL Sentry v10 : Index Analysis

Aaron Bertrand (@AaronBertrand) provides some insight into a new feature in SQL Sentry v10, and coming soon to Plan Explorer : Index Analysis.

Bad cardinality estimates from SSMS plans – redux

Aaron Bertrand (@AaronBertrand) shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.

Paul White : Another Reason to Use NOEXPAND hints in Enterprise Edition

Paul White (@SQL_Kiwi) goes into detail about another reason you'll want to use the NOEXPAND hint, even when using Enterprise Edition.