Category Archives: Index
-
What happens if I disable the clustered index?
1December 16, 2019 by Kenneth Fisher
You are probably already aware that you can disable an index. This can be handy when you have a large …
Continue reading -
My fantasy SQL feature(s)? T-SQL Tuesday #118
3September 10, 2019 by Kenneth Fisher
It’s fantasy football time again? Oh, fantasy feature? Oh, yea, that makes a lot more sense for #tsql2sday. What’s #tsql2sday? …
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 -
SQL Homework – April 2018 – Indexes
Leave a commentApril 2, 2018 by Kenneth Fisher
This month we are going to look at a topic near and dear to both database developers and database administrators …
Continue reading -
DBA Definitions: FILLFACTOR
1November 6, 2017 by Kenneth Fisher
It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing …
Continue reading -
Uniquifier is a rather unique word isn’t it?
8September 18, 2017 by Kenneth Fisher
tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique. Uniquifier is a rather funny …
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 -
When was my index created or at least last updated?
1November 14, 2016 by Kenneth Fisher
SQL Server stores a create date and a change date for each object in the sys.objects system view. Unfortunately while …
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 -
Too many indexes!
6October 13, 2016 by Kenneth Fisher
Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work. Different indexes work …
Continue reading