Category Archives: Query Plans
-
Temporary stored procedures
Leave a commentAugust 7, 2019 by Kenneth Fisher
tl;dr; Temporary stored procedures are excellent for testing pieces of code that are going to go into (or come from) …
Continue reading -
Hugo’s SQL Server Execution Plan Reference
1March 18, 2019 by Kenneth Fisher
I’m a big fan of T-SQL Tuesday. Each month there is a host who comes up with a topic, and …
Continue reading -
SQL Homework – January 2018 – Inspect an Execution Plan
6January 3, 2018 by Kenneth Fisher
It’s a new year and yet education never ends. So this month let’s take a look at an important part …
Continue reading -
What is the “cost” in Cost Threshold for Parallelism?
3April 17, 2017 by Kenneth Fisher
tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s …
Continue reading -
New indexes, hypothetically
1November 2, 2016 by Kenneth Fisher
I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought …
Continue reading -
Comparing two query plans
3June 14, 2016 by Kenneth Fisher
This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server. …
Continue reading -
Using LEN wrong.
4June 2, 2016 by Kenneth Fisher
I was reading someone’s question the other day on StackExchange and while the existing comments/questions solved the OP’s (original poster) …
Continue reading -
Getting a query plan
3February 19, 2014 by Kenneth Fisher
Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware …
Continue reading -
A better way to find missing indexes
13November 11, 2013 by Kenneth Fisher
I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a …
Continue reading -
Physical Join Operators by Ami Levin
Leave a commentNovember 6, 2013 by Kenneth Fisher
For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these …
Continue reading
SQL Studies 