• Title SQL Server Execution Plans, 3rd Edition
• Author(s) Grant Fritchey
• Publisher: Red Gate Books (October 1, 2018); eBook (Online Edition)
• Paperback 520 pages
• eBook PDF (515 pages)
• Language: English
• ISBN-10: 1910035246
• ISBN-13: 978-1910035245; 978-1910035221 (Online Edition)
• Share This:  

Book Description

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.

This book has the singular goal of teaching you how to read SQL Server Execution plans. It will explain, among many other things, the following:

• How to capture execution plans using manual and automatic methods
• A documented method for reading and interpreting execution plans
• How common SQL Server objects, such as indexes, views, stored procedures, and so on, appear in execution plans
• How to control execution plans with hints and plan guides, and why this is a double-edged sword
• How the Query Store works with, and collects data on, execution plans

With this knowledge, you'll have everything you need to read the execution plan, for any query of your own, regardless of complexity, and understand what it does and what is causing the bad performance. It is still your job to work out how best to fix it, but your new understanding of execution plans will give a much better chance of success!

• Grant Fritchey, Microsoft Data Platform MVP, has more than twenty years experience in IT. That time was spent in technical support, development and database administration.

• Amazon

• Miscrosoft SQL Server
• Database, Data Warehouse and Data Management
• Microsoft Windows and .NET

• SQL Server Execution Plans, 3rd Edition (Grant Fritchey)
• The Mirror Site (1) - PDF
• The Mirror Site (2) - PDF

• Inside the SQL Server Query Optimizer (Benjamin Nevarez)

  The author's insight will leave you with an excellent foundation in the practicalities of the Query Optimizer, and everything you need to know to start tuning your queries to perfection.

• SQL Server Hardware Choices Made Easy (Glenn Berry)

  This book is designed to provide the fundamental knowledge and resources you need to make intelligent choices about optimal installation and configuration of SQL Server hardware, operating system and the SQL Server RDBMS.

• Transact-SQL: The Building Blocks to SQL Server Programming

  This book will cover different aspects of the Transact SQL (TSQL) language. It takes the readers step by step through the TSQL language, one concept at a time. Each topic covers a particular aspect of TSQL with discussion and examples.

• SQL Server Concurrency: Locking, Blocking and Row Versioning

  This book is for anyone using SQL Server as a programmer, an administrator, or even a user, who wants to understand how SQL Server manages multiple sessions, and what causes excessive blocking.

• SQL Server Backup and Restore (Shawn McGehee)

  This book shows you how to set-up a reliable, tested, SQL Server backup and restore plan. Get tips for recovering your data with minimum downtime. Learn how to minimize data loss when disaster strikes.

• SQL Server Team-based Development

  How to use of mixture of home-grown scripts, native SQL Server tools, and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment, and make database development as "normal" development.

• Performance Tuning with SQL Server Dynamic Management Views

  This book investigates all of the DMVs that are most frequently useful to the DBA in investigating query execution, index usage, session and transaction activity, disk IO, and how SQL Server is using or abusing the operating system.

• Learn T-SQL Querying (Pedro Lopes, et al)

  The book will get you started with query processing fundamentals to help you write powerful, performant Transact-SQL (T-SQL) queries. You will then focus on query execution plans and learn how to leverage them for troubleshooting.

• 45 Database Performance Tips for Developers (Phil Factor, et al)

  Speed up your development with ORMs and discover the gotchas' involved. Learn the best practices for efficiently indexing tables. Get expert advice on writing well-formed SQL queries. Topics covered: ORM Tips, T-SQL Tips, Index Tips, Database Design Tips.

• SQL Server Integration Services (SSIS) Succinctly (Rui Machado)

  With this book, you will learn how to build and deploy your own ETL solution in a drag-and-drop development environment by using SSIS packages, control flows, data flows, tasks, and more.