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

Active August #2

by Grant Fritchey

The Scary DBA

Hrmmm… 198. Up four pounds. That just doesn’t seem possible. I did a tabata on Monday. I did have a...

2009-08-08

532 reads

Presenting “Understanding Execution Plans”

by Grant Fritchey

The Scary DBA

The PASS Application Development SIG is hosting a web cast next week on Tuesday where I’ll be presenting Understanding Execution...

2009-08-07

819 reads

24 Hours of PASS

by Grant Fritchey

The Scary DBA

I’m fairly certain Jack Bauer isn’t involved with this new initiative from PASS. Just as I’m also certain I won’t...

2009-08-03

730 reads

Pain of the Week Webcast

by Grant Fritchey

The Scary DBA

Thursday this week I get to hang out, virtually, with some of the heavy hitters of the industry, Brent Ozar,...

2009-08-03

518 reads

SQL Server Standard

by Grant Fritchey

The Scary DBA

PASS is relaunching the SQL Server Standard with a wholly new approach and format. I’ll put more out about it...

2009-08-03

711 reads

Active August #1

by Grant Fritchey

The Scary DBA

I like to blog about technical topics and community, not personal stuff. However, this is a community post. A number...

2009-08-01

618 reads

No really. When did this statement start?

by Grant Fritchey

The Scary DBA

I thought I had an interesting answer to the question. Unfortunately Adam Machanic, who has been working in this specific...

2009-07-31

1,313 reads

PASS & SQL Bloggers

by Grant Fritchey

The Scary DBA

PASS is trying to find better ways to reach out to SQL Bloggers. They’re going to experiment with taking advantage...

2009-07-31

1,311 reads

When did this statement start?

by Grant Fritchey

The Scary DBA

UPDATE: This post is incorrect. Adam nailed it in the comments. I explain my mistake here.
A question came up over...

2009-07-28

1,872 reads

Attache/Brief Case Review

by Grant Fritchey

The Scary DBA

Steve Jones, through a series of comments, emails, blackmail, back-alley deals & tons of whining, agreed to let me review a...

2009-07-24

566 reads

Blogs

In Memory of Andrew Clarke, AKA Phil Factor

One of the parts of getting older that really sucks is I seem to...

Leading Through the Noise: Harnessing Data in the Age of Digital Overload

The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....

A New Word: Anderance

anderance – n. the awareness that your partner perceives the relationship from a totally...

Read the latest Blogs

Forums

taking the rcsi dive

Hi, we put together an extract that runs every 15 minutes against what i...

Parameter Sensitive Plan Optimization in SQL Server 2022

By Deepam Ghosh

Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...

Minimum Change Tracking Retention

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Minimum Change Tracking Retention

Visit the forum

Question of the Day

Minimum Change Tracking Retention

If I am running this code:

ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);

What is the minimum amount of time I can set?

See possible answers