Category Archives: Query Plans
-
Code that made you feel a certain way : T-SQL Tuesday #164
3July 11, 2023 by Kenneth Fisher
It’s been a while, but I’m finally participating in T-SQL Tuesday again! This month Erik Darling (blog|twitter) is hosting. Ever …
Continue reading -
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
SQL Studies 