Tag Archives: index

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

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

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

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

  6. Does a clustered index sort the rows within a page

    Leave a comment

    December 15, 2014 by Kenneth Fisher

    This is just something I was curious about. I ran my tests and got an answer and now I thought …
    Continue reading

  7. DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD

    6

    December 11, 2014 by Kenneth Fisher

    I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do …
    Continue reading

  8. Using a date or int column as the clustered index.

    13

    December 1, 2014 by Kenneth Fisher

    The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on …
    Continue reading

  9. Adding a column to the primary key.

    13

    November 13, 2014 by Kenneth Fisher

    Every now and again you realize that the primary key for a table does not uniquely describe a row. Not …
    Continue reading

  10. Force only certain values to be unique

    1

    October 22, 2014 by Kenneth Fisher

    I thought of something rather interesting the other day while answering a question asking for help with some table structures. …
    Continue reading

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

Join 2,470 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013