Let us learn today in this quick guide Execution Plans and Indexing Strategies. Your comments are welcome
SQL SERVER – Catching Non-SARGable Queries in Action
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 – Performance: OR vs IN
I recently asked on Twitter an exciting question about OR vs IN. While I got lots of good answers, there were an equal amount of wrong answers.
Parameter Sensitive Plan optimization in SQL Server 2022 – SQL in Sixty Seconds #200
SQL Server 2022 introduces Parameter Sensitive Plan Optimization (PSPO), a feature that revolutionizes the performance of parameterized queries.
Remove Key Lookup – SQL in Sixty Seconds #194
Today, we are going to see one more trick from the book – Remove Key Lookup and improve the performance of queries.