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

Operations Manager Feedback

by Grant Fritchey

The Scary DBA

If you’re involved with maintaining Microsoft Operations Manager, you probably have a few things you’d like to tell the developers,...

2009-10-13

516 reads

Table Variables Are Only in Memory: Fact or Myth

by Grant Fritchey

The Scary DBA

I keep seeing these concepts that have long been disproven, posted again and again on newsgroups as if they were valid information. The...

2009-10-13

669 reads

3 Weeks to the PASS Summit

by Grant Fritchey

The Scary DBA

The PASS Summit is only three weeks away and I’m getting awfully excited. It’s not too late to register. Heck,...

2009-10-10

628 reads

Another Book

by Grant Fritchey

The Scary DBA

Well, part of one anyway. I wrote three chapters of Rob Walter’s new book, Beginning SQL Server 2008 Administration. I...

2009-10-10

541 reads

PASS Log Reader Awards

by Grant Fritchey

The Scary DBA

Brent Ozar, Andy Warren and Jeremiah Peschka have put together a blogger award called the PASS Log Reader Award. I...

2009-10-08

719 reads

SNESSUG September Meeting

by Grant Fritchey

The Scary DBA

We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and...

2009-10-08

595 reads

Ad Hoc Queries Don’t Reuse Execution Plans: Myth or Fact

by Grant Fritchey

SQLServerCentral.com

Blogs

Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2009-10-07

3,203 reads

Hey, ho, where’d you go…

by Grant Fritchey

The Scary DBA

Ohio?
I’m presenting on Thursday to the Columbus SQL Server Users Group, home of the newly minted MVP, Jeremiah Peschka (congrats again)....

2009-10-06

527 reads

Ad Hoc Queries Don’t Reuse Execution Plans: Myth or Fact

by Grant Fritchey

The Scary DBA

Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...

2009-10-05

3,199 reads

Free Stuff and a SQL Server Standard Update

by Grant Fritchey

The Scary DBA

Great news. We’ve managed to get one article all the way through the process. We’ll have our first publication out...

2009-10-02

713 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