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

PASS Summit Birds of a Feather Lunch

by Grant Fritchey

The Scary DBA

The absolute biggest part of the PASS Summit is the one thing that most people don’t take advantage of, networking....

2010-10-13

590 reads

Speaking at SNESSUG

by Grant Fritchey

The Scary DBA

I’ll be presenting tonight at the Southern New England SQL Server Users Group (SNESSUG). The topic is “Using DMVs as...

2010-10-13

684 reads

SQL Saturday New England: The New Date

by Grant Fritchey

The Scary DBA

The real world can get in the way of important things like SQL Saturday. In the case of SQL Saturday...

2010-10-12

563 reads

SQL Saturday New England: The Date

by Grant Fritchey

The Scary DBA

Mark your calendars. Make your travel arrangements. Plan on being in the Boston area on April 16th, 2011. Three of...

2010-10-05

539 reads

How to Tell if Execution Plans are Reused

by Grant Fritchey

The Scary DBA

I try to watch the search phrases that point people to the blog because sometimes, you get a sense of...

2010-10-04

443 reads

SQL Saturday in New England

by Grant Fritchey

The Scary DBA

Adam Machanic (blog|twitter) has put on a SQL Saturday/Data camp event in New England for the last two years. I’ve...

2010-10-04

394 reads

Parameter Name Size And Performance

by Grant Fritchey

The Scary DBA

I saw an odd statement the other day, “The size of the name of the parameter does not affect performance.”...

2010-09-27

1,023 reads

SQL Saturday 46 (#sqlsat46) Recap

by Grant Fritchey

The Scary DBA

I was privileged to be able to attend and present at SQL Saturday 46 in Raleigh, NC, this last weekend....

2010-09-20

822 reads

Links From Twitter

by Grant Fritchey

The Scary DBA

Normally, I try to stick to posting technical info or community stuff on the blog, but there were a couple...

2010-09-07

568 reads

Recursive Hiearchies in Reporting Services

by Grant Fritchey

The Scary DBA

I am not a Reporting Services guru and nor do I play one on TV. I am however forced to...

2010-09-03

2,651 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