Category Archives: Index

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

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

  3. Filtered Index restrictions and Kendra Little’s Index Quiz

    3

    July 20, 2015 by Kenneth Fisher

    A few weeks ago I saw a tweet about Kendra Little’s (b/t) new SQL Server Quizzes. Of course I had …
    Continue reading

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

  5. DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD

    2

    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

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

    9

    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

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

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

  9. Update to “The clustered index columns are in all of the non clustered indexes.”

    4

    October 20, 2014 by Kenneth Fisher

    I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments …
    Continue reading

  10. SchemaBinding – What & Why

    10

    August 6, 2014 by Kenneth Fisher

    What When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 847 other followers