Category Archives: Performance

  1. When good enough is good enough

    3

    August 30, 2022 by Kenneth Fisher

    Any time I’ve learned about the optimizer there is always one important thing that’s brought up. The optimizer is not …
    Continue reading

  2. SQL Server Query Tuning and Optimization by Benjamin Nevarez

    Leave a comment

    August 16, 2022 by Kenneth Fisher

    I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin Nevarez (blog|twitter), and as soon as …
    Continue reading

  3. Why do DBAs dislike loops?

    5

    August 22, 2019 by Kenneth Fisher

    If you started out as a developer you were probably taught how important loops are. They are one of the …
    Continue reading

  4. Temporary stored procedures

    Leave a comment

    August 7, 2019 by Kenneth Fisher

    tl;dr; Temporary stored procedures are excellent for testing pieces of code that are going to go into (or come from) …
    Continue reading

  5. Yes, pulling just the data you need is really important.

    Leave a comment

    April 24, 2019 by Kenneth Fisher

    I was asked the other day why a customer was having performance issues on a table. A simple SELECT that …
    Continue reading

  6. Disabling Indexes

    3

    January 28, 2019 by Kenneth Fisher

    Indexes are probably the number one tool we have to improve performance. That said, there are times when we want …
    Continue reading

  7. SQL Homework – January 2019 – Baselines

    Leave a comment

    January 2, 2019 by Kenneth Fisher

    Happy New Year! Every year for New Years we all make a big deal of coming up with New Years …
    Continue reading

  8. I/O vs Logical I/O

    Leave a comment

    September 5, 2018 by Kenneth Fisher

    tl;dr; While the difference is very important 90% of the time you won’t care and should just add the two …
    Continue reading

  9. SQL Homework – January 2018 – Inspect an Execution Plan

    6

    January 3, 2018 by Kenneth Fisher

    It’s a new year and yet education never ends. So this month let’s take a look at an important part …
    Continue reading

  10. Why shouldn’t I shrink my database data file?

    3

    November 20, 2017 by Kenneth Fisher

    A while back I did a post about why you shouldn’t shrink your log file. This one is going to …
    Continue reading

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

Join 3,709 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013