Get updates about SQL Server 2019, as well as helpful tips and guides to make sure you get the most out of your experience.

From in-database analytics to mobile reports, view the Microsoft SQL Server 2019 functions and features that deliver breakthrough performance for your data platform.

SQL query optimization aims to choose an optimal Query Execution Plan (QEP) for a query. The existing optimizers usually choose the plan with the minimal execution cost. However, in some real ...

To view query plan or missing indexes, call static QueryPlanVisualizer.DumpPlan(query) method or call DumpPlan extension method on an IQueryable instance. You will also need to add ...

SQL Server 2019 Diagnostic Information Queries.sql Copy path Blame Blame ...

SQL Server 2019 introduces a custom capture option that enables you to fine-tune data collection to avoid this issue. Additionally, there are a number of enhancements around execution plan collection.

When I switched the compatibility mode to 150 (using SQL Server 2019), the same query took 900 milliseconds and the execution plan showed all of the detail of the function's execution.

If you want to speed up your SQL Server queries you need to know how your application and your users actually use your database.