Category Archives: Performance
-
What is production grade code? : T-SQL Tuesday #156
1November 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 -
When good enough is good enough
3August 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 -
SQL Server Query Tuning and Optimization by Benjamin Nevarez
Leave a commentAugust 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 -
Why do DBAs dislike loops?
5August 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 -
Temporary stored procedures
Leave a commentAugust 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 -
Yes, pulling just the data you need is really important.
Leave a commentApril 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 -
Disabling Indexes
3January 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 -
SQL Homework – January 2019 – Baselines
Leave a commentJanuary 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 -
I/O vs Logical I/O
Leave a commentSeptember 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 -
SQL Homework – January 2018 – Inspect an Execution Plan
6January 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
SQL Studies 