Category Archives: Performance

  1. Why shouldn’t I shrink my database log file?

    1

    May 15, 2017 by Kenneth Fisher

    TL;DR: It’s pretty pointless and can cause performance issues. Let’s start by asking why you might want to shrink your …
    Continue reading

  2. When should I add an index?

    7

    April 19, 2017 by Kenneth Fisher

    We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we …
    Continue reading

  3. Increasing and decreasing the performance level of your Azure SQL Database

    Leave a comment

    March 29, 2017 by Kenneth Fisher

    One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability …
    Continue reading

  4. Queries with optional parameters

    11

    February 27, 2017 by Kenneth Fisher

    These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or …
    Continue reading

  5. Lead Blocker

    7

    January 18, 2017 by Kenneth Fisher

    Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and …
    Continue reading

  6. Reload a table quickly.

    4

    November 21, 2016 by Kenneth Fisher

    Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload. …
    Continue reading

  7. SQLSkills waits and latches library

    2

    November 16, 2016 by Kenneth Fisher

    SQLSkills is an amazing resource for the SQL Server community. Between their blogs, white papers, and the SQLSkills Insider emails …
    Continue reading

  8. New indexes, hypothetically

    1

    November 2, 2016 by Kenneth Fisher

    I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought …
    Continue reading

  9. Natural vs Artificial Primary Keys

    2

    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

  10. RBAR vs Batch

    7

    August 17, 2016 by Kenneth Fisher

    Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s …
    Continue reading

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

Join 1,682 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013