Table of Contents

An Introduction to Query Tuning and Optimization

Troubleshooting Queries

The Query Optimizer

The Execution Engine

Working with Indexes

Understanding Statistics

In-Memory OLTP

Understanding Plan Caching

The Query Store

Intelligent Query Processing

An Introduction to Data Warehouses

Understanding Query Hints

About the Author

Benjamin Nevarez is a database professional based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of several books including “High Performance SQL Server'', “SQL Server 2017 on Linux”, “SQL Server 2014 Query Tuning & Optimization” and “Inside the SQL Server Query Optimizer” and has also co-authored other books such as “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences around the world