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
Another day and another interesting question by a client Do we still get a bad plan after disabling Parameter Sniffing? Yes!
SQL SERVER – Applying Query Hints to Views
I totally agree that it is not possible to apply query hints to views inside the view. It will give you an error. However, there is a workaround.
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.
Auditing Query Hints Left in Production Code
Start auditing query hints in modules and Query Store, rank the busiest statements, and test removal with measured plans and rollback.
SQL SERVER – Disable Rowgoal Optimizer
In my career, this is I think 2 or 3 rd time I have seen this one, so do not consider this as a generic solution. How to Disable Rowgoal Optimizer works?