Category Archives: Performance

  1. Code that made you feel a certain way : T-SQL Tuesday #164

    3

    July 11, 2023 by Kenneth Fisher

    It’s been a while, but I’m finally participating in T-SQL Tuesday again! This month Erik Darling (blog|twitter) is hosting. Ever …
    Continue reading

    Category: Documentation, Microsoft SQL Server, Performance, Query Plans, SQLServerPedia Syndication, T-SQL Tuesday | Tags: , , , ,

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

    1

    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

    Category: Documentation, Performance, SQLServerPedia Syndication, T-SQL Tuesday | Tags: , , ,

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

    Category: Performance, SQLServerPedia Syndication

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

    Category: Book Review, Microsoft SQL Server, Performance, SQLServerPedia Syndication | Tags: , ,

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

    Category: Microsoft SQL Server, Performance, SQLServerPedia Syndication, T-SQL | Tags: , , ,

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

    Category: Microsoft SQL Server, Performance, Query Plans, SQLServerPedia Syndication, T-SQL | Tags: , ,

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

    Category: Microsoft SQL Server, Performance, SQLServerPedia Syndication | Tags: ,

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

    Category: Index, Microsoft SQL Server, Performance, SQLServerPedia Syndication | Tags: , ,

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

    Category: Microsoft SQL Server, Performance, Reporting, Settings, SQL Homework, SQLServerPedia Syndication | Tags: , , , ,

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

    Category: Microsoft SQL Server, Performance, SQLServerPedia Syndication | Tags: , ,

« Older Entries

Follow me via RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

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

Join 3,978 other subscribers

Follow me on Twitter

@sqlstudent144