Let us learn today in this quick guide Execution Plans and Indexing Strategies. Your comments are welcome
SQL SERVER – Exploring 3 Overutilized Features
Potentially leading to less efficient implementations or missed opportunities for optimization. In this blog post, we’ll explore three such Overutilized features.
SQL SERVER – Parameter Sniffing and Bad Plan
Disabling parameter sniffing does not guarantee that a bad plan becomes good. That remains my answer to the customer question.
Query Hints on a View in SQL Server: Where OPTION Goes
Query hints on a view cannot sit inside the view. Learn where OPTION goes, what a view may contain, and how Query Store hints help.
Change Join Type for a Query: HASH, LOOP and MERGE Hints
To change join type for a query, add one of three hints to its OPTION clause. This post runs one join with each hint on two filters and compares the join type and the logical reads. It shows that no join type is best in general, and what a join hint in the FROM clause does to the join order.
sys.dm_exec_valid_use_hints: Every USE HINT Your Server Knows
sys.dm_exec_valid_use_hints lists every USE HINT name that your SQL Server accepts. This post groups the 35 names on SQL Server 2025 and shows the compile error for a misspelled hint. It applies two hints and reads the plan to prove each one worked, then compares USE HINT with QUERYTRACEON.
USE HINT: Switching Off One Optimizer Rule Without Trace Flags
Apply USE HINT to one query, inspect supported names, compare optimizer behavior, and manage Query Store hints with a clear removal plan.