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.
SQL SERVER – COUNT(*) and Index Used
DBA suspects those operations are using lots of clustered index scans. Let us discuss today COUNT(*) and Index Used. Let’s learn.