How to perform a large delete operation
Deleting data from your production databases can be tricky. You can either choose TRUNCATE or DELETE statements to suit your need. Here in this blog, I will focus more on…
Beyond Query Tuning
Writing efficient queries following best practices is a sign of a good database developer. However, for it to perform at the intended level there are more knobs to turn. Let…
Query Tuning – Best Practices
In my last post, I talked about how I measure query performances. Let's talk about some of the best practices around query design so that we do not have to…
How to measure query performance
One of your production queries out of nowhere started to run slow and users aren’t happy. Application takes forever to load its screen because of course, the query retrieving data…