Tag Archives: Performance
-
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?
3May 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 -
Is the network your last performance bottleneck?
6July 18, 2016 by Kenneth Fisher
Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options …
Continue reading
