Blog: Grant Fritchey

213 blogs updated: 50 min. ago
Forcing a Plan That Has a Plan Guide
The question that came up during a recent class I was teaching was: What if you have a plan guide to get the plan you want, but then decide,...
26-11-2018 17:01:21 Grant Fritchey SQL Server
Bad Query Performance Tips Rebutted
Once upon a time, someone, somewhere, wrote a list of bad query performance tips and they've been copied all over the internet, over and ove...
12-11-2018 17:08:09 Grant Fritchey SQL Server
Explicitly Drop Temporary Tables Or Wait For Cleanup?
I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn't remember the specific...
29-10-2018 16:20:37 Grant Fritchey SQL Server
Why Did a Plan Get Removed From Cache?
I was recently asked if we could tell why a plan was removed from cache. If you read this blog, you know what I'm going to say next. I check...
22-10-2018 16:44:22 Grant Fritchey SQL Server
Using Extended Events to Capture Implicit Conversions
Using the appropriate data type to avoid conversions or implicit conversions is a fundamental approach to good T-SQL coding practices. Impli...
16-10-2018 10:37:35 Grant Fritchey SQL Server
Query Store and Log Backups
A question that came up recently around Query Store is what happens when there are log backups in use on the database. Let's talk about it. ...
17-09-2018 16:25:27 Grant Fritchey SQL Server
Estimated Plans and Forced Plans from Query Store
While all plans are estimated plans, there is still a difference between capturing an estimated plan and looking at a plan from the cache or...
10-09-2018 16:18:53 Grant Fritchey SQL Server
Actual Execution Plan Costs
Why don't "actual execution plans" have "actual execution plan costs"? This is a question and a myth I have to fight against all the time. I...
20-08-2018 17:24:06 Grant Fritchey SQL Server
Measuring Query Execution Time: What Is Most Accurate
Probably the single most important factor when deciding which query to tune, or actively tuning a query, is how you go about measuring query...
13-08-2018 17:07:02 Grant Fritchey SQL Server
What Is The Preferred Join Operator in SQL Server?
I schedule many of my blog posts at least 2-3 weeks out, so I have time to adjust them, change, them, insert new things into the schedule, w...
09-07-2018 17:18:50 Grant Fritchey SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.