Book
SQL Server Query Tuning and Optimization
This book helps you get up to speed with both query engine internals and practical query optimization. As you progress, you’ll explore ready-to-use techniques for creating high-performance queries and applications.
Offered by
Difficulty Level
Intermediate
Completion Time
14h52m
Language
English
About Book
Who Is This Book For?
This book is for SQL Server developers who are struggling with slow query execution, database administrators who are tasked with troubleshooting slow application performance, and database architects who design SQL Server databases in support of line-of-business and data warehousing applications.
SQL Server Query Tuning and Optimization
- About Book
- Who Is This Book For?
- Book Content
Book content
chapters • 14h52m total length
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
Related Resources
Access Ready-to-Use Books for Free!
Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!