Targeted Plan Cache Removal
A lot of times you’ll hear how people are experiencing sudden, intermittent, poor performance on a query, bad parameter sniffing...
2015-09-02 (first published: 2015-08-24)
1,587 reads
Grant Fritchey
- 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
Time to Change
I recently spent two days consulting with a company on their database development and deployment processes. They are a small, capable, team...
2015-08-19
756 reads
Generating Estimated Plan and the Plan Cache
Does generating an Estimated Plan cause that plan to be loaded into the plan cache?
No.
What? Still here? You want more?...
2015-08-18 (first published: 2015-08-10)
1,785 reads
PASS Board Update: July 2015
I was actually travelling for most of July and some of that was on holiday with the family, the real...
2015-08-13
589 reads
Leadership: A Name and A Principle
I’m actively working to put together the leadership course that I talked about here and here. No, not full time. I...
2015-08-11
510 reads
Grant’s Fly-by-night Leadership Course – The Plan
Get a better nameDefine my personal goals for the courseI won’t be sharing these with you. I may share them...
2015-08-07 (first published: 2015-07-28)
1,896 reads
Reading Your Execution Plans
I’m putting the finishing touches on the all day seminar on execution plans that I’ll be putting on at DevConnections this...
2015-08-06
931 reads
PASS Needs You!
It’s time.
No more procrastinating. No more complaining about the process from the outside. No more excuses.
You have to run for...
2015-08-05
580 reads
But we've always done it that way…
Inspired by his visit to the battlefield of Waterloo, Grant Fritchey explains the dangers of doing things the way you've always done them and the need to challenge constantly your beliefs and understanding of how the technology you manage works.
2015-08-03
160 reads
Differences Between Actual & Estimated Plans
I have, in the past, made way too much of the need for Actual Plans when doing performance troubleshooting. The...
2015-08-03
881 reads
Blogs
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers