Could you hire me? Contact me if you like what I’ve done in this article and think I can create value for your company with my skills.
Read the article, and I reveal the exact gain I made. :) This week I worked on two optimization tasks. They were…
We made a query 600 times faster in the first part. Then, we optimized it more in the second part, making it…
In the previous article, I showed how to speed up a query by 600 times. In this part, I’ll demonstrate how we…
One of my clients struggled with the following query: Sometimes it was fast, and sometimes it was slow. It seemed the query…
In the previous part, I introduced a strange problem. A SQL Server occasionally used an excessive amount of memory, much more than…
This was a very bizarre case. An SQL Server instance unpredictably and suddenly ate all memory of the server and even more…
My recent troubleshooting engagement was about a SQL server blocking problem. Imagine an insurance web application with large forms. The app automatically…
I wrote about a build pipeline recently. It is a multi-job DevOps server pipeline that runs integration tests in parallel. I wrote…
This is a short story about a SQL Server troubleshooting job from 2014. The Plan Cache Hit Ratio was 60%. There was…