Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud
暫譯: Azure SQL 和 SQL Server 2022 專家性能指數：實現更快的結果與更低的維護成本，無論是在本地還是雲端

Pollack, Edward, Strate, Jason

Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud
  • 出版商: Apress
  • 出版日期: 2023-02-22
  • 售價: $2,970
  • 貴賓價: 9.5 折 $2,822
  • 語言: 英文
  • 頁數: 638
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484292146
  • ISBN-13: 9781484292143
  • 相關分類: Microsoft Azure、MSSQL、SQL

    • 海外代購書籍(需單獨結帳)

相關主題

商品描述

Take a deep dive into perhaps the single most important facet of query performance--indexes--and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other updates to help you optimize query execution and make performance improvements to even the most challenging workloads.
The book begins with explanations of the types of indexes and how they are stored in a database. Moving further into the book, you will learn how statistics are critical for optimal index usage and how the Index Advisor can assist in reviewing and optimizing index health. This book helps you build a clear understanding of how indexes work, how to implement and use them, and the many options available to tame even the most large and complex workloads.

What You Will Learn

  • Properly index row store, columnstore, and memory-optimized tables
  • Make use of Intelligent Query Processing for faster query results
  • Review statistics to understand indexing choices made by the optimizer
  • Apply indexing strategies such as covering indexes, included columns, and index intersections
  • Recognize and remove unnecessary indexes
  • Design effective indexes for full-text, spatial, and XML data types


Who This Book Is For
Azure SQL and SQL Server administrators and developers who are ready to improve the performance of their database environment by thoughtfully building indexes to speed up queries that matter the most and make a difference to the business

 

商品描述(中文翻譯)

深入探討查詢效能中或許是最重要的面向——索引——以及如何最佳利用它們。本書第四版已針對 SQL Server 2022 和 Azure SQL 進行更新，包含有關列存儲索引的新指導和功能、改進和整合的查詢存儲內容、關於智能查詢處理的更深入內容，以及其他幫助您優化查詢執行和提升即使是最具挑戰性工作負載的效能的更新。

本書首先解釋了索引的類型以及它們在資料庫中的儲存方式。隨著書籍的深入，您將學習到統計數據對於最佳索引使用的重要性，以及索引建議工具如何協助檢查和優化索引健康。本書幫助您清楚理解索引的運作方式、如何實施和使用它們，以及可用來駕馭即使是最龐大和複雜工作負載的多種選項。

您將學到的內容


  • 正確地為行存儲、列存儲和記憶體優化表進行索引

  • 利用智能查詢處理以獲得更快的查詢結果

  • 檢查統計數據以了解優化器所做的索引選擇

  • 應用索引策略，如覆蓋索引、包含列和索引交集

  • 識別並移除不必要的索引

  • 為全文、本地和 XML 資料類型設計有效的索引

本書適合誰閱讀

Azure SQL 和 SQL Server 管理員及開發人員，準備透過精心構建索引來提升其資料庫環境的效能，以加速最重要的查詢並對業務產生影響。

作者簡介

Edward Pollack has over 20 years of experience in database and systems administration, architecture, and development, becoming an advocate for designing efficient data structures that can withstand the test of time. He has spoken at many events, such as SQL Saturdays, PASS Data Community Summit, Dativerse, and at many user groups and is the organizer of SQL Saturday Albany. Ed has authored many articles, as well as the following Apress books: Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads; and a chapter in Expert T-SQL Window Functions in SQL Server. His first patent was issued in 2021, focused on the compression of geographical data for use by analytic systems.
In his free time, Ed enjoys video games, sci-fi and fantasy, traveling, and baking. He lives in the sometimes-frozen icescape of Albany, NY, with his wife Theresa and sons Nolan and Oliver, and a mountain of (his) video game plushies that help break the fall when tripping on (their) toys.

Jason Strate is a database architect and administrator with more than 15 years of experience. He has been a recipient of Microsoft's Most Valuable Professional designation for SQL Server since July 2009. His experience includes design and implementation of both OLTP and OLAP solutions, as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. He is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008.
Jason is actively involved with his local PASS chapter (SQL Server User Group) and serves as its director of program development. He worked with the board to organize the PASSMN SQL Summit 2009 for the local community. He enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Most recently, he has presented at the SSWUG Virtual Conferences, TechFuse, numerous SQL Saturdays, and at PASSMN user group meetings.
Jason is a contributing author for the Microsoft whitepaper on "Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition." He is an active blogger with a focus on SQL Server and related technologies.

作者簡介(中文翻譯)

Edward Pollack 擁有超過 20 年的資料庫和系統管理、架構及開發經驗，並成為設計能夠經得起時間考驗的高效資料結構的倡導者。他曾在許多活動中發言，例如 SQL Saturdays、PASS Data Community Summit、Dativerse，以及許多使用者群組，並且是 SQL Saturday Albany 的組織者。Ed 撰寫了許多文章，以及以下 Apress 書籍：Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server、Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads；以及在 Expert T-SQL Window Functions in SQL Server 中的一章。他的第一項專利於 2021 年發放，專注於地理資料的壓縮，以供分析系統使用。

在空閒時間，Ed 喜歡玩電子遊戲、科幻和奇幻小說、旅行以及烘焙。他與妻子 Theresa 和兒子 Nolan 及 Oliver 住在有時會結冰的紐約 Albany，並且有一堆（他的）電子遊戲毛絨玩具，幫助在絆倒（他們的）玩具時減輕摔倒的衝擊。

Jason Strate 是一位資料庫架構師和管理員，擁有超過 15 年的經驗。自 2009 年 7 月以來，他一直是微軟 SQL Server 的最有價值專業人士（MVP）。他的經驗包括 OLTP 和 OLAP 解決方案的設計與實施，以及對 SQL Server 環境的最佳實踐、性能和高可用性解決方案的評估與實施。他是 SQL Server 的 MCITP，並參與了微軟 SQL Server 2008 認證考試的開發。

Jason 積極參與當地的 PASS 分會（SQL Server 使用者群組），並擔任其計畫發展主任。他與董事會合作，為當地社區組織了 PASSMN SQL Summit 2009。他喜歡幫助 SQL Server 社區中的其他人，並通過在技術會議和使用者群組會議上發表演講來實現這一點。最近，他在 SSWUG 虛擬會議、TechFuse、眾多 SQL Saturdays 和 PASSMN 使用者群組會議上發表了演講。

Jason 是微軟白皮書《Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition》的貢獻作者。他是一位活躍的部落客，專注於 SQL Server 及相關技術。

類似商品