Tag Archives: Performance

  1. What is production grade code? : T-SQL Tuesday #156


    November 8, 2022 by Kenneth Fisher

    It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would …
    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?


    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


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

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


    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

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


    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

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


    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

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

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013