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