June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 2

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Index, SQL Scripts
This article is follow up of my previous article SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup. Please do read my previous article before continuing further. I have described there two different methods to reduce query execution cost. Let us compare…
Read More

SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query

Pinal Dave
SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Index, SQL Scripts, SQL White Papers
Recently, I was working on an optimization project for one of the large organizations. While working on one of the queries, we came across a very interesting observation. We found that there was a query on the base table and when the query was run, it used the index, which…
Read More

SQL SERVER – Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location

Pinal Dave
SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Documentation
I was reading the blog of Ward Pond, and I came across another note of Microsoft. I really found it very interesting. The given explanation was very simple; however, I would like to rewrite it again. Let us execute the following script. This script inserts two values ‘A’ and ‘B’…
Read More