If you ever wondered why a query that looks harmless is performing poorly despite having indexes in place, the answer could non-SARGable queries.
SQL SERVER Performance Tuning: Catching Key Lookup in Action
In this blog post, we’ll explore what a Key Lookup is, how to spot it, and most importantly, how to eliminate it using a covering index.
Majoring in the Minors in SQL Server Performance Tuning
We’ll explore how to avoid this common pitfall & Focus the areas that matter for performance improvements. Avoid majoring in the minors.Â
SQL SERVER – Ins and Outs of Online Index Operations
I recently talked about Ins and Outs of Online Index Operations with my clients during the Comprehensive Database Performance Health Check.
SQL SERVER – Performance: OR vs IN – A Summary and Further Reading
The varied responses led me to write a detailed blog post to clarify the correct answer. If you missed it, you can read it here. Let us see A Summary and Further Reading.
SQL SERVER – Measure Index Performance
My client reached out to me asking if there is a way to measure the performance of the newly created index. How to measure index performance.Â
SQL SERVER – COUNT(*) and Index Used – Part 2
Yesterday I wrote a blog post on the topic SQL SERVER – COUNT(*) and Index Used, lots of people asked me to follow up question.