Category Archives: Index

  1. SchemaBinding – What & Why

    25

    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

  2. The clustered index columns are in all of the non clustered indexes.

    13

    July 30, 2014 by Kenneth Fisher

    Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes …
    Continue reading

  3. DBA Myths: A table with a primary key is not a heap

    5

    May 21, 2014 by Kenneth Fisher

    Typically when you see a heading like this you know the answer is “No” or “False” but in this case …
    Continue reading

  4. DBA Myths: An index on a bit column will never be used.

    4

    February 17, 2014 by Kenneth Fisher

    Not true. (Or I guess probably wouldn’t be posting about it would I?) Probably the first thing I should point …
    Continue reading

  5. A better way to find missing indexes

    12

    November 11, 2013 by Kenneth Fisher

    I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a …
    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

  7. Small changes, big effects

    Leave a comment

    January 30, 2013 by Kenneth Fisher

    We got a call last week about an application that was running slowly. The server was showing about 80% CPU …
    Continue reading

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

Join 2,486 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013