Category Archives: Index

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

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

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

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

  5. Too many indexes!

    4

    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

  6. Natural vs Artificial Primary Keys

    2

    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

  7. Remove files from a filegroup

    Leave a comment

    May 2, 2016 by Kenneth Fisher

    You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve …
    Continue reading

  8. Pulling data from a non-clustered index

    1

    March 14, 2016 by Kenneth Fisher

    This is one of those things that I found very interesting but figured I’d probably never really use. Of course …
    Continue reading

  9. To the page and back again

    1

    January 18, 2016 by Kenneth Fisher

    To the page It’s not one of those things you have to do frequently but every now and again you …
    Continue reading

  10. Using unique constraints

    10

    December 10, 2015 by Kenneth Fisher

    I ran into an interesting problem the other day. Given the title of the post, obviously a unique constraint was …
    Continue reading

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

Join 2,134 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013