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

Clustered Indexes Have Statistics Too

by Grant Fritchey

The Scary DBA

It may seem obvious, but I’ve heard more than one person suggest to me that statistics on a clustered index...

2012-10-22

1,162 reads

SQL In The City: Seattle

by Grant Fritchey

The Scary DBA

If you missed all the great speakers on the five city tour of SQL in the City, don’t despair. Many...

2012-10-17

1,147 reads

Why Tune Queries?

by Grant Fritchey

The Scary DBA

It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or...

2012-10-17 (first published: 2012-10-15)

3,000 reads

RML Utilities and SQL Server 2012

by Grant Fritchey

The Scary DBA

I’m working through some code that I haven’t touched recently and I’m running it for the first time on a...

2012-10-16

1,477 reads

Interviewing a DBA

by Grant Fritchey

The Scary DBA

I’m not a fan of trivia style interview questions. Yes, I ask a few because you have to in order...

2012-09-26 (first published: 2012-09-24)

3,350 reads

PASS Elections 2012

by Grant Fritchey

The Scary DBA

Yeah, it’s that time again. And we have a magnificent slate of people running. I mean truly amazing and wonderful...

2012-09-21

709 reads

Conference in Florida: SQL Server Live

by Grant Fritchey

The Scary DBA

This conference is new to me. In case it’s new to you, I thought I’d take a moment to point...

2012-09-14

979 reads

SSC Clinic: Finding the rogue query

by Grant Fritchey

SQLServerCentral.com

Memory

When you're getting spikes of high CPU, it's quite likely it's a rogue query. But how do you find out which query? Grant Fritchey explains, using SQL Monitor.