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

SQL Server Standard Update

by Grant Fritchey

The Scary DBA

We’ve received wonderful support from the community. Brad McGehee has a list with great people on it who have volunteered...

2009-08-29

1,655 reads

New Book

by Grant Fritchey

The Scary DBA

Well, three chapters. The latest book I worked on is up at Apress. I only have three chapters in this...

2009-08-25

561 reads

PASS Board Nominations

by Grant Fritchey

The Scary DBA

I think the Professional Association of SQL Server users (PASS) is an extremely important organization for SQL Server DBA’s. Even...

2009-08-25

661 reads

What happens when you use WITH RECOMPILE

by Grant Fritchey

The Scary DBA

I saw this question and my immediate thought was “Well, duh, the execution plan is recreated by a recompile.” But,...

2009-08-21

1,321 reads

Two Book Recommendations

by Grant Fritchey

The Scary DBA

I have two new books that I can heartily recommend. This isn’t a review of either book since I’ve only...

2009-08-20

566 reads

SQL Server Standard Writing Guidelines

by Grant Fritchey

The Scary DBA

Well, actually, these are the guidelines for submitting anything to SQLPASS, but it includes the guidelines for SQL Server Standard....

2009-08-13

1,167 reads

Excellent Blog List

by Grant Fritchey

The Scary DBA

For the one or two you that are not reading Buck Woody’s blog (and why aren’t you), you may not...

2009-08-12

702 reads

SQL Quiz 5: SANs Mirroring

by Grant Fritchey

The Scary DBA

My turn to answer Chris Shaw’s questions “Do I feel I have a reliable SAN solution?” and “Describe Database Mirroring...

2009-08-12

627 reads

Some Statement Start Times!

by Grant Fritchey

The Scary DBA

I thought I had captured statement start times within the DMV sys.dm_exec_sessions. I was absolutely wrong. However, this has sparked...

2009-08-11

946 reads

Microsoft Thrive

by Grant Fritchey

The Scary DBA

I was introduced to the Thrive program when my user group held a Thrive event back in March. Since then...

2009-08-09

544 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