SQL Server Execution Plans For SQL Server 2008 through to 2017 and Azure SQL Database 3rd Edition by Grant Fritchey ISBN 1910035246 978-1910035245

SQL Server Execution Plans For SQL Server 2008 through to 2017 and Azure SQL Database 3rd Edition by Grant Fritchey – Ebook PDF Instant Download/Delivery: 1910035246, 978-1910035245

Full download SQL Server Execution Plans For SQL Server 2008 through to 2017 and Azure SQL Database 3rd Edition after payment

 

Product details:

ISBN 10: 1910035246 

ISBN 13: 978-1910035245

Author: Grant Fritchey

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.

I wrote this book with the singular goal of teaching you how to read SQL Server Execution plans

Table of contents: 

Chapter 1: Introducing the Execution Plan

Chapter 2: Getting Started Reading Plans

Chapter 3: Data Reading Operators

Chapter 4: Joining Data

Chapter 5: Sorting and Aggregating Data

Chapter 6: Execution Plans for Data Modifications

Chapter 7: Execution Plans for Common T-SQL Statements

Chapter 8: Examining Index Usage

Chapter 9: Exploring Plan Reuse

Chapter 10: Controlling Execution Plans with Hints

Chapter 11: Parallelism in Execution Plans

Chapter 12: Batch Mode Processing

Chapter 13: The XML of Execution Plans

Chapter 14: Plans for Special Data Types and Cursors

Chapter 15: Automating Plan Capture

Chapter 16: The Query Store

Chapter 17: SSMS Tools for Exploring Execution Plans

People also search for:

reading sql server execution plans
how to compare sql server execution plans
understanding sql server execution plans
sql server execution plan analysis
sql server execution plan analysis tool online

Tags:

Grant Fritchey,SQL Serve,Execution Plan,Server