Learn T-SQL Querying - Second Edition: A guide to developing efficient and elegant T-SQL code

Troubleshoot query performance issues, identify anti-patterns in your code, and write efficient T-SQL queries with this guide for T-SQL developers

Key Features:

• A definitive guide to mastering the techniques of writing efficient T-SQL code
• Learn query optimization fundamentals, query analysis, and how query structure impacts performance
• Discover insightful solutions to detect, analyze, and tune query performance issues
• Purchase of the print or Kindle book includes a free PDF eBook

Book Description:

Data professionals seeking to excel in Transact-SQL (T-SQL) for Microsoft SQL Server and Azure SQL Database often lack comprehensive resources. This updated second edition of Learn T-SQL Querying focuses on indexing queries and crafting elegant T-SQL code, catering to all data professionals seeking mastery in modern SQL Server versions and Azure SQL Database.

Starting with query processing fundamentals, this book lays a solid foundation for writing performant T-SQL queries. You'll explore the mechanics of the Query Optimizer and Query Execution Plans, learning how to analyze execution plans for insights into current performance and scalability. Through dynamic management views (DMVs) and dynamic management functions (DMFs), you'll build diagnostic queries. This book thoroughly covers indexing for T-SQL performance and provides insights into SQL Server's built-in tools for expedited resolution of query performance and scalability issues. Further, hands-on examples will guide you through implementing features such as avoiding UDF pitfalls, understanding predicate SARGability, Query Store, and Query Tuning Assistant.

By the end of this book, you'll have developed the ability to identify query performance bottlenecks, recognize anti-patterns, and skillfully avoid such pitfalls.

What You Will Learn:

• Identify opportunities to write well-formed T-SQL statements
• Familiarize yourself with the Cardinality Estimator for query optimization
• Create efficient indexes for your existing workloads
• Implement best practices for T-SQL querying
• Explore Query Execution Dynamic Management Views
• Utilize the latest performance optimization features in SQL Server 2017, 2019, and 2022
• Safeguard query performance during upgrades to newer versions of SQL Server

Who this book is for:

This book is for database administrators, database developers, data analysts, data scientists and T-SQL practitioners who want to master the art of writing efficient T-SQL code and troubleshooting query performance issues through practical examples. A basic understanding of T-SQL syntax, writing queries in SQL Server, and using the SQL Server Management Studio tool will be helpful to get started.

解決查詢性能問題、識別代碼中的反模式，並撰寫高效的 T-SQL 查詢，這本指南專為 T-SQL 開發人員而設。

主要特點：
- 成為精通撰寫高效 T-SQL 代碼的權威指南
- 學習查詢優化基礎知識、查詢分析以及查詢結構對性能的影響
- 發現檢測、分析和調整查詢性能問題的深入解決方案
- 購買印刷版或 Kindle 版本的書籍將包含免費的 PDF 電子書

書籍描述：
尋求在 Microsoft SQL Server 和 Azure SQL Database 中精通 Transact-SQL (T-SQL) 的數據專業人士通常缺乏全面的資源。這本更新的第二版《學習 T-SQL 查詢》專注於索引查詢和精緻 T-SQL 代碼的撰寫，適用於所有希望在現代 SQL Server 版本和 Azure SQL Database 中掌握技能的數據專業人士。

從查詢處理基礎知識開始，本書為撰寫高效的 T-SQL 查詢打下了堅實的基礎。您將探索查詢優化器和查詢執行計劃的運作原理，學習如何分析執行計劃以獲得有關當前性能和可擴展性的見解。通過動態管理視圖 (DMV) 和動態管理函數 (DMF)，您將構建診斷查詢。本書全面介紹了 T-SQL 性能索引，並提供了有關 SQL Server 內置工具的見解，以加快解決查詢性能和可擴展性問題。此外，實際示例將指導您實施功能，例如避免 UDF 陷阱、理解謂詞 SARGability、查詢存儲和查詢調整助手。

通過閱讀本書，您將能夠識別查詢性能瓶頸，識別反模式並巧妙避免這些陷阱。

學到的內容：
- 識別撰寫格式良好的 T-SQL 語句的機會
- 熟悉用於查詢優化的基數估算器
- 為現有工作負載創建高效的索引
- 實施 T-SQL 查詢的最佳實踐
- 探索查詢執行動態管理視圖
- 利用 SQL Server 2017、2019 和 2022 中的最新性能優化功能
- 在升級到新版本的 SQL Server 過程中保護查詢性能

適合閱讀對象：
本書適合數據庫管理員、數據庫開發人員、數據分析師、數據科學家和 T-SQL 實踐者，他們希望通過實際示例掌握撰寫高效 T-SQL 代碼和解決查詢性能問題的技巧。對 T-SQL 語法、在 SQL Server 中撰寫查詢以及使用 SQL Server Management Studio 工具有基本的理解將有助於入門。