Empower T-SQL developers with the skills to troubleshoot query performance issues, identify anti-patterns in their code and write efficient T-SQL queries Key Features An all-in-one guide to master the techniques of writing efficient T-SQL code Learn query optimization fundamentals, query analysis, and how query structure impacts performance Insightful solutions to detect, analyze, and tune query performance issues Book DescriptionTransact-SQL (T-SQL) is Microsoft’s proprietary extension to the SQL language used with Microsoft SQL Server and Azure SQL Database. This 2nd edition is for all data professionals who want to master the art of writing efficient T-SQL code in modern SQL Server versions, as well as Azure SQL Database. The book starts with query processing fundamentals to help you write solid, performant T-SQL queries. You will be introduced to the mechanics of the Query Optimizer. Later you will explore Query Execution Plans. It will help you analyze execution plans to gain insights into current performance and gauge whether a query is scalable. You will learn to build diagnostic queries using dynamic management views (DMVs) and dynamic management functions (DMFs) to unlock the secrets of T-SQL execution. Next, you will learn about indexing for T-SQL Performance. You will also learn about SQL Server built-in tools to shorten the time to address query performance and scalability issues. You will learn to implement various features such as Avoiding UDF pitfalls, Understanding Predicate SARGability, Query Store, and Query Tuning Assistant using hands-on examples. By the end of the book, you will be able to determine where query performance bottlenecks are, understand what anti-patterns may be in use, and how to avoid such pitfalls as we advance.What you will learn Identify opportunities to write well-formed T-SQL statements Get familiar with the Cardinality Estimator Create efficient indexes for your existing workloads Best practices for T-SQL querying Explore Query Execution DMVs Utilize the latest performance optimization features in SQL Server 2017, 2019, and 2022 Protect query performance during upgrades to newer versions of SQL Server Who this book is forThis 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 using practical examples. A basic understanding of T-SQL syntax, writing queries in SQL Server, and using the SQL Server Management Studio tool is helpful to get started.

Book Information
ISBN 9781837638994
Author Pam Lahoud
Format Paperback
Imprint Packt Publishing Limited
Publisher Packt Publishing Limited