Tag Archives: Performance
-
Why do DBAs dislike loops?
5August 22, 2019 by Kenneth Fisher
If you started out as a developer you were probably taught how important loops are. They are one of the …
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 -
Yes, pulling just the data you need is really important.
Leave a commentApril 24, 2019 by Kenneth Fisher
I was asked the other day why a customer was having performance issues on a table. A simple SELECT that …
Continue reading -
Disabling Indexes
3January 28, 2019 by Kenneth Fisher
Indexes are probably the number one tool we have to improve performance. That said, there are times when we want …
Continue reading -
I/O vs Logical I/O
Leave a commentSeptember 5, 2018 by Kenneth Fisher
tl;dr; While the difference is very important 90% of the time you won’t care and should just add the two …
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 -
Why shouldn’t I shrink my database data file?
3November 20, 2017 by Kenneth Fisher
A while back I did a post about why you shouldn’t shrink your log file. This one is going to …
Continue reading -
Why shouldn’t I shrink my database log file?
10May 15, 2017 by Kenneth Fisher
TL;DR: It’s pretty pointless and can cause performance issues. Let’s start by asking why you might want to shrink your …
Continue reading -
When should I add an index?
7April 19, 2017 by Kenneth Fisher
We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we …
Continue reading -
Increasing and decreasing the performance level of your Azure SQL Database
Leave a commentMarch 29, 2017 by Kenneth Fisher
One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability …
Continue reading