Category Archives: Index

  1. What happens if I disable the clustered index?


    December 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

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


    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

  3. Disabling Indexes


    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

  4. 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

  5. DBA Definitions: FILLFACTOR


    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

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


    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

  7. When should I add an index?


    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

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


    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

  9. New indexes, hypothetically


    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

  10. Too many indexes!


    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

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

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013