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

Minor Celebration

by Grant Fritchey

The Scary DBA

A little cheap thrill for me. I passed 50,000 views on the blog yesterday. Thanks to everyone who has stopped...

2009-09-30

1,382 reads

Pre-Compiled Stored Procedures: Fact or Myth

by Grant Fritchey

The Scary DBA

There’s a very common belief among DBA’s: Stored procedures are pre-compiled. I had someone tell me all about it just...

2009-09-30

1,903 reads

Vote for Mr. LaRock

by Grant Fritchey

The Scary DBA

It is rapidly coming up on election time at the Professional Association of SQL Server users (PASS). Once more, a person...

2009-09-29

1,566 reads

Recap of Cape Cod .NET User’s Group

by Grant Fritchey

The Scary DBA

I presented last night at the Cape Cod .NET User’s Group. What a great bunch of people. About 20 people...

2009-09-24

709 reads

PASS Virtual Chapters

by Grant Fritchey

The Scary DBA

If you’re not a member of the Professional Association of SQL Server users, PASS, why not? No, I’m sorry. I...

2009-09-23

865 reads

Presentation Skills from Brent Ozar

by Grant Fritchey

The Scary DBA

If you present at any level, read this. If you’re thinking about presenting, read this. If you’d like to start...

2009-09-23

1,073 reads

Cape Cod .NET Users Group

by Grant Fritchey

The Scary DBA

Tomorrow night, Wednesday, September 23, I’m going to present on “Best Practices for Working with SQL Server Execution Plans” for the...

2009-09-22

836 reads

Gila Monster on Estimated vs. Actual Row Counts

by Grant Fritchey

The Scary DBA

I don’t generally do lots of blog aggregation and cross post linking & stuff. It’s just not something I’m that into....

2009-09-22

1,284 reads

Identifying Frequently Running Queries

by Grant Fritchey

The Scary DBA

It’s not enough to look at the longest running query. What if you have two queries, one runs for 5...

2009-09-21

960 reads

More Free Training

by Grant Fritchey

The Scary DBA

Quest Connect 2009, taking place in October 21 for 24 hours, looks like it’s going to have 64 different sessions, live...

2009-09-15

692 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