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

Is Performance Better With LEFT JOIN or RIGHT JOIN?

by Grant Fritchey

The Scary DBA

I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give...

2015-05-20 (first published: 2015-05-11)

7,077 reads

I Am Grateful For…

by Grant Fritchey

The Scary DBA

I’m almost done reading the book Connected (will be by the time this is published). It’s fascinating although, at least so...

2015-05-15

507 reads

Effects of Persisted Columns on Performance

by Grant Fritchey

The Scary DBA

I live for questions. And my favorite questions are the ones where I’m not completely sure of the answer. Those...

2015-05-13 (first published: 2015-05-05)

5,931 reads

Speaker of the Month: May 2015

by Grant Fritchey

The Scary DBA

I finally got out to some community events last month and got to see a bunch of great speakers. Not...

2015-05-01

508 reads

Benefits for Some, All or Only a Few

by Grant Fritchey

The Scary DBA

As a member of the PASS Board of Directors I attended the PASS Business Analytics Conference (BAC) recently. You can...

2015-04-27

519 reads

Azure SQL Database Firewall Settings

by Grant Fritchey

The Scary DBA

The new portal for managing Azure is pretty. I’m not sure I’m in love with it, but it’s pretty.
However, one...

2015-04-24 (first published: 2015-04-13)

5,251 reads

PASS Board Update: April 2015

by Grant Fritchey

The Scary DBA

It’s been a pretty interesting month on the board.
First, we did have a little problem. I’m sure one or two...

2015-04-23

528 reads

Query Hash Formula Changes Between Versions

by Grant Fritchey

The Scary DBA

The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on...

2015-04-21

627 reads

Azure SQL Database v12 and SQL Magazine

by Grant Fritchey

The Scary DBA

I spend many of my evenings researching and writing. Sometimes it’s writing new books. Sometimes it’s fixing and rewriting old...

2015-04-16

684 reads

Constraints and SELECT Statements

by Grant Fritchey

The Scary DBA

I’ve posted previously about how a foreign key constraint can change how a SELECT query behaves. Logically that just makes...

2015-04-16 (first published: 2015-04-06)

7,520 reads

Blogs

Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python

By Eduardo Pivaral

Most apps that call an LLM send every request to the same model. That...

Advice I Like: Responsibility

“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...

Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports

Originally published April 2022; substantially updated July 2026. This post is a complete replacement...

Read the latest Blogs

Forums

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

By abdalah.mehdoini

Hello everyone , I am planning to migrate a database from SQL Server 2014...

SQL Agent Job Automated Change Capture Process

By James Greaves

Comments posted to this topic are about the item SQL Agent Job Automated Change...

Another Model, More Data Loss

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Another Model, More Data Loss

Visit the forum

Question of the Day

Finding a Database Master Key

Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?

See possible answers