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.
Category: Plan Explorer (3)
Aaron Bertrand reveals a new build of SQL Sentry Plan Explorer, updated to support the new add-in model introduced with the latest SSMS.
Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE..
Rob Farley looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.
Aaron Bertrand provides some insight into a new feature in SQL Sentry v10, and coming soon to Plan Explorer: Index Analysis.
Aaron Bertrand shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.
Aaron Bertrand describes a few different causes for a symptom you might describe as a "runaway" query in SQL Server.
Jason Hall shows off some of the new features in a brand new update for Plan Explorer.
Aaron Bertrand explains how to get Plan Explorer to work with plans from the latest builds of Azure SQL DB and CTPs of SQL Server 2016.
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.
Aaron Bertrand gives detail about an important enhancement in the latest release of SQL Sentry Plan Explorer, v2.7: better anonymization.
Aaron Bertrand shows how to use the RunAs command to connect the SQL Sentry Client, Plan Explorer, or SSMS to a database in another domain.
Aaron Bertrand posts the slide deck and links from his recent presentation on SQL Sentry Plan Explorer at SQL Saturday #357 in Cleveland.
Paul White talks about coercing the optimizer into avoiding sorts, reminding us that sound indexing should still be our first line of...
Paul White looks at a couple of cases where - even though T-SQL is supposed to be a declarative language and any query that uses the...
