Category Archives: Performance
-
‘Twas 4:45 Friday
3December 16, 2014 by Kenneth Fisher
‘Twas 4:45 Friday, and all through the office not a creature was stirring, not even the bosses. The code was …
Continue reading -
Two simple commands that can be a big help in performance tuning.
10September 2, 2014 by Kenneth Fisher
The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are …
Continue reading -
T-SQL Tuesday #49: Wait for it
3December 10, 2013 by Kenneth Fisher
It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits. …
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 -
Brad Shultz’s blog on reviewing your database
1September 17, 2013 by Kenneth Fisher
This is possibly the best blog I have every read on the subject of reviewing a database. It is witty, …
Continue reading -
Small changes, big effects
Leave a commentJanuary 30, 2013 by Kenneth Fisher
We got a call last week about an application that was running slowly. The server was showing about 80% CPU …
Continue reading -
Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text
4November 12, 2012 by Kenneth Fisher
I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats …
Continue reading
SQL Studies 