Category Archives: Query Plans
-
Getting a query plan
Leave a commentFebruary 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
11November 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 -
Comparing an inner join vs a subquery
11May 2, 2013 by Kenneth Fisher
I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing …
Continue reading
