Tag Archives: Performance
-
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?
2November 20, 2017 by Kenneth Fisher
A while back I did a post about why you shouldn’t shrink your data file. This one is going to …
Continue reading -
Why shouldn’t I shrink my database log file?
8May 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 -
Queries with optional parameters
11February 27, 2017 by Kenneth Fisher
These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or …
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 -
Natural vs Artificial Primary Keys
3August 29, 2016 by Kenneth Fisher
There has been a long standing debate over the use of a natural primary key vs an artificial one. I …
Continue reading -
RBAR vs Batch
8August 17, 2016 by Kenneth Fisher
Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s …
Continue reading
