Category Archives: Index

  1. SchemaBinding – What & Why

    6

    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.

    9

    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

    4

    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

    11

    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

Follow

Get every new post delivered to your Inbox.

Join 401 other followers