Joey on SQL Server. Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization. Reduce workload times with this handy feature that can benefit every database pro.

If you're seeking to optimize your SQL queries and make the most of your database, this fundamental guide is an excellent resource. You'll learn the essential techniques to enhance database ...

In earlier versions of SQL Server, after selecting a join algorithm, SQL Server had to process it even if a better alternative might be available. In SQL Server 2017, the query optimizer can now sense ...

The Query Optimizer: Q&A with Microsoft's David DeWitt Database administrators and developers converged on Seattle for this week's annual Professional Association for SQL Server (PASS) conference, ...

SQL Query Store is a new feature offered in SQL Server 2016 that allows DBAs to see which queries ran when, how often and with what performance results to optimize queries and query plan selection.

Melissa Demos Analytics Techniques Using Data Quality for SQL Server at PASS Summit RANCHO SANTA MARGARITA, Calif., Nov. 1, 2019 – Melissa , a leading provider of global address, name, email, phone, ...

In this two-part series, I'll tell you about some improvements Microsoft is making in SQL Server 2022 to improve cardinality estimates and deal with another common query optimization concern ...