Category Archives: Index

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

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

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

  4. 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 160 other followers