Tag Archives: indexes

  1. Too many indexes!

    Leave a comment

    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

  2. Natural vs Artificial Primary Keys


    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

  3. To the page and back again


    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

  4. Using unique constraints


    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

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


    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

  6. Query to compare indexes between two tables

    Leave a comment

    October 16, 2013 by Kenneth Fisher

    We have a set of databases at my office that use the load and swap method of loading data with …
    Continue reading

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

Join 1,580 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013