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

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

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

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

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

  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

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

  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

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

  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

    Category: DBCC, 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