SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance (Paperback)

Fritchey, Grant

SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance (Paperback)
  • 出版商: Apress
  • 出版日期: 2022-11-10
  • 定價: $2,200
  • 售價: 9.5 折 $2,090
  • 貴賓價: 9.0 折 $1,980
  • 語言: 英文
  • 頁數: 720
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484288904
  • ISBN-13: 9781484288900
  • 相關分類: MSSQL、SQL

    • 立即出貨 (庫存=1)

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

商品描述

Covers cutting-edge features like Query Store, adaptive execution plans, automated tuning in Azure.

Current with SQL Server 2017, while also covering older editions back to 2012.

Alerts you to changes in the cardinality estimation and query optimization engines that can lead to poor performance.

Describes new tooling introduced in SQL Server 2017 SQL Server Management Studio.

商品描述(中文翻譯)

本書涵蓋了最新的功能，如查詢存儲、自適應執行計劃和在Azure中的自動調整。

本書與SQL Server 2017保持同步，同時也涵蓋了從2012年開始的舊版本。

本書提醒您注意基數估算和查詢優化引擎的變化，這可能導致性能下降。

本書介紹了SQL Server 2017 SQL Server Management Studio中引入的新工具。

作者簡介

Grant Fritchey is a Microsoft Data Platform MVP and AWS Community Builder. He has more than 30 years of experience in IT technical support, development, and database administration. He currently works as Product Advocate at Red Gate Software. Grant writes articles for publication at SQL Server Central and Simple-Talk. He has published books, including SQL Server Execution Plans and SQL Server 2017 Query Performance Tuning (Apress). He has written chapters for Beginning SQL Server 2012 Administration (Apress), SQL Server Team-based Development, SQL Server MVP Deep Dives Volume 2, Pro SQL Server 2012 Practices (Apress), Expert Performance Indexing in SQL Server (Apress), and Query Store for SQL Server 2019 (Apress). Grant presents live sessions, virtual sessions, and recorded content online and in-person, all around the world.

作者簡介(中文翻譯)

Grant Fritchey 是一位微軟資料平台 MVP 和 AWS 社群建立者。他在 IT 技術支援、開發和資料庫管理方面擁有超過 30 年的經驗。他目前在 Red Gate Software 擔任產品倡導者。Grant 在 SQL Server Central 和 Simple-Talk 上發表文章。他出版了多本書籍，包括《SQL Server Execution Plans》和《SQL Server 2017 Query Performance Tuning》（Apress）。他還為《Beginning SQL Server 2012 Administration》（Apress）、《SQL Server Team-based Development》、《SQL Server MVP Deep Dives Volume 2》、《Pro SQL Server 2012 Practices》（Apress）、《Expert Performance Indexing in SQL Server》（Apress）和《Query Store for SQL Server 2019》（Apress）撰寫了章節。Grant 在全球各地進行現場會議、虛擬會議和線上錄製內容的演講。

類似商品