SQL Server Query Tuning and Optimization: Optimize Microsoft SQL Server 2022 queries and applications (Paperback)

Get well-versed with ready-to-use techniques for creating high-performance queries and applications

Key Features

- Speed up queries and dramatically improve application performance by both understanding query engine internals and practical query optimization
- Understand how the query optimizer works
- Learn about intelligent query processing and what is new in SQL Server 2022

Book Description

SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.

This book starts by describing the inner workings of the query optimizer, and will enable you to use this knowledge to write better queries and provide the query engine with all the information it needs to produce efficient execution plans. As you progress, you'll get practical query optimization tips for troubleshooting underperforming queries. The book will also guide you through intelligent query processing and what is new in SQL Server 2022. Query performance topics such as the Query Store, In-Memory OLTP and columnstore indexes are covered as well.

By the end of this book, you'll be able to get the best possible performance for your queries and applications.

What you will learn

- Troubleshoot queries using methods including extended events, SQL Trace, and dynamic management views
- Understand how the execution engine and query operators work
- Speed up queries and improve app performance by creating the right indexes
- Detect and fix cardinality estimation errors by examining query optimizer statistics
- Monitor and promote both plan caching and plan reuse to improve app performance
- Troubleshoot and improve query performance by using the Query Store
- Improve the performance of data warehouse queries by using columnstore indexes
- Handle query processor limitations with hints and other methods

Who this book is 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 2022的新功能。

書籍描述：

SQL Server是由Microsoft開發的關聯式數據庫管理系統。作為一個數據庫服務器，它是一個軟件產品，其主要功能是根據其他軟件應用程序的請求存儲和檢索數據。

本書首先描述了查詢優化器的內部工作原理，並使您能夠利用這些知識撰寫更好的查詢並為查詢引擎提供所需的所有信息以生成高效的執行計劃。隨著學習的進展，您將獲得用於疑難查詢的實用查詢優化技巧。本書還將指導您進行智能查詢處理以及SQL Server 2022的新功能。還涵蓋了查詢性能主題，如查詢存儲、內存OLTP和列存儲索引。

通過閱讀本書，您將能夠為您的查詢和應用程序獲得最佳性能。

您將學到什麼：

- 使用擴展事件、SQL跟蹤和動態管理視圖等方法來疑難查詢。
- 了解執行引擎和查詢運算符的工作原理。
- 通過創建正確的索引來加快查詢速度並改善應用程序性能。
- 通過檢查查詢優化器統計信息來檢測和修復基數估算錯誤。
- 監控和促進計劃緩存和計劃重用以提高應用程序性能。
- 使用查詢存儲優化和改進查詢性能。
- 通過使用列存儲索引來提高數據倉庫查詢的性能。
- 使用提示和其他方法處理查詢處理器的限制。

本書適用對象：

本書適用於正在努力解決緩慢查詢執行的SQL Server開發人員，被指派解決應用程序性能緩慢的數據庫管理員，以及設計支持業務線和數據倉庫應用程序的SQL Server數據庫的數據庫架構師。

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

Benjamin Nevarez 是一位位於加州洛杉磯的資料庫專業人士，專精於 SQL Server 查詢調校和優化。他是多本書的作者，包括《高效能 SQL Server》、《SQL Server 2017 on Linux》、《SQL Server 2014 查詢調校與優化》和《Inside the SQL Server Query Optimizer》，並且也參與合著了其他書籍，如《SQL Server 2012 Internals》。Benjamin 也曾在世界各地的 SQL Server 會議上擔任講者。

1. An Introduction to Query Tuning and Optimization
2. Troubleshooting Queries
3. The Query Optimizer
4. The Execution Engine
5. Working with Indexes
6. Understanding Statistics
7. In-Memory OLTP
8. Understanding Plan Caching
9. The Query Store
10. Intelligent Query Processing
11. An Introduction to Data Warehouses
12. Understanding Query Hints

1. 查詢調整和優化介紹
2. 查詢故障排除
3. 查詢優化器
4. 執行引擎
5. 使用索引
6. 瞭解統計資料
7. 內存 OLTP
8. 瞭解計劃緩存
9. 查詢存儲
10. 智能查詢處理
11. 數據倉庫介紹
12. 瞭解查詢提示