Grant Fritchey

Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Advocate in January 2011. Find Grant on Twitter @GFritchey or on his blog as the Scary DBA.

SQL Server Execution Plans eBook, Third Edition, by Grant Fritchey

SQL Server Execution Plans, Third Edition, by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance.

5 (3)

2020-07-28

1,008 reads

SQL Server Execution Plans Second Edition eBook Download

SQL Server Execution Plans, Second Edition by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.

2012-11-12

16,924 reads

SQL Server Team-Based Development eBook cover

The Red Gate Guide to SQL Server Team-based Development

This book shows 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 similar as possible to "normal" development.

2010-10-21

4,800 reads

Technical Article

SQL Server Execution Plans

Every day, out in the SQL Server forums, the same questions come up again and again: why is this query running slow? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed book on this essential topic.

2009-02-10

46,022 reads

Blogs

SQL Saturday Jacksonville Slide Decks

By

Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...

Power BI connectors to Azure Synapse

By

When using Power BI and pulling data from Azure Synapse, you will use the...

Snowflake + Azure Privatelink

By

Azure Privatelink provides private connectivity from an Azure Virtual Network to Azure PaaS such...

Read the latest Blogs

Forums

Hi everyone!

By robenson55

I'm Johnson, and I've just joined these forums. I was looking on Google for...

Filetred index

By aureliu

\hello Guys,   Mayyou help wuth the corect index filetred creation using modulo?  ...

Monitor SQL Server Job Failures

By ktflash

Ahoi, i am usually working with SSIS and SSAS, but since there is no...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers