SQL Server Query Tuning and Optimization: Optimize Microsoft SQL Server 2022 queries and applications (Paperback)
暫譯: SQL Server 查詢調優與優化：優化 Microsoft SQL Server 2022 查詢與應用程式 (平裝本)

Nevarez, Benjamin

SQL Server Query Tuning and Optimization: Optimize Microsoft SQL Server 2022 queries and applications (Paperback)
  • 出版商: Packt Publishing
  • 出版日期: 2022-08-12
  • 售價: $1,980
  • 貴賓價: 9.5 折 $1,881
  • 語言: 英文
  • 頁數: 446
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1803242620
  • ISBN-13: 9781803242620
  • 相關分類: MSSQL、SQL

    • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

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 是由微軟開發的關聯式資料庫管理系統。作為一個資料庫伺服器，它是一種軟體產品，主要功能是根據其他軟體應用程式的要求存儲和檢索資料。

本書首先描述查詢優化器的內部運作，並使您能夠利用這些知識撰寫更好的查詢，並為查詢引擎提供其所需的所有資訊，以生成高效的執行計劃。隨著進展，您將獲得實用的查詢優化技巧，以排除性能不佳的查詢問題。本書還將指導您了解智能查詢處理及 SQL Server 2022 的新功能。查詢性能主題，如查詢存儲 (Query Store)、內存 OLTP 和列存儲索引 (columnstore indexes) 也會涵蓋。

在本書結束時，您將能夠為您的查詢和應用程式獲得最佳性能。

您將學到什麼

- 使用擴展事件、SQL Trace 和動態管理視圖等方法排除查詢問題

- 了解執行引擎和查詢運算子的工作原理

- 通過創建正確的索引來加速查詢並改善應用程式性能

- 通過檢查查詢優化器統計資訊來檢測和修正基數估算錯誤

- 監控並促進計劃快取和計劃重用，以改善應用程式性能

- 使用查詢存儲 (Query Store) 來排除和改善查詢性能

- 通過使用列存儲索引來改善資料倉儲查詢的性能

- 使用提示和其他方法處理查詢處理器的限制

本書適合誰

本書適合面臨查詢執行緩慢的 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》（High Performance SQL Server）、《Linux 上的 SQL Server 2017》（SQL Server 2017 on Linux）、《SQL Server 2014 查詢調優與優化》（SQL Server 2014 Query Tuning & Optimization）以及《SQL Server 查詢優化器內部》（Inside the SQL Server Query Optimizer），並且共同撰寫了其他書籍，如《SQL Server 2012 內部原理》（SQL Server 2012 Internals）。本傑明也曾在全球多個 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. 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

類似商品

最後瀏覽商品 (12)