Category Archives: Index

  1. My fantasy SQL feature(s)? T-SQL Tuesday #118

    3

    September 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

  2. Disabling Indexes

    3

    January 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

  3. SQL Homework – April 2018 – Indexes

    Leave a comment

    April 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

  4. DBA Definitions: FILLFACTOR

    1

    November 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

  5. Uniquifier is a rather unique word isn’t it?

    8

    September 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

  6. When should I add an index?

    7

    April 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

  7. When was my index created or at least last updated?

    1

    November 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

  8. New indexes, hypothetically

    1

    November 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

  9. Too many indexes!

    5

    October 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

  10. Natural vs Artificial Primary Keys

    4

    August 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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,085 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013