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.

Twitter: @https://twitter.com/gfritchey
Website: https://scarydba.com
LinkedIn: https://www.linkedin.com/in/grant-fritchey/
Bluesky: https://bsky.app/profile/gfritchey.bsky.social

All authors

Estimated Costs of All Queries

by Grant Fritchey

The Scary DBA

One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty...

2017-02-22 (first published: 2017-02-20)

2,517 reads

Approaching Politics in IT

by Grant Fritchey

SQLServerCentral.com

Editorial

The news cycle seems to be dominated by discussion of politics. Regardless of where you fall on the political spectrum, the talk of politics is inescapable and is probably going to lead to you being displeased with your fellow man. Luckily, we work in IT, so we can avoid politics. BWA-HA-HA-HA-HA! Politics goes way beyond […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2017-02-20

141 reads

Discuss

Does Query Store Pre-Allocate Space

by Grant Fritchey

The Scary DBA

I love the questions I get while I’m presenting because they force me to think and learn. The question in...

2017-02-14 (first published: 2017-02-07)

1,514 reads

Export All Plans From Cache to a .SQLPLAN File

by Grant Fritchey

The Scary DBA

I was asked if there was an easy way to export all the plans from cache to a .SQLPLAN file....

2017-02-13

868 reads

Still Grateful to Rodney Landrum

by Grant Fritchey

The Scary DBA

So, my blog got hacked. They edited the page where I thanked Rodney for all that he did. I had...

2017-02-06

440 reads

I have been hacked

by Grant Fritchey

The Scary DBA

I’m working on securing the blog. Please stand by. Apologies for any inconvenience or confusion.
The post I have been hacked...

2017-02-05

601 reads

SQL Server Execution Plans, Second Edition by Grant Fritchey

by Grant Fritchey

SQLServerCentral.com

books

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.