Apply query store hints to a vendor query without code changes, verify failures and plan behavior, then clear the hint after the real fix.
Timed-Out Queries in Query Store: Finding Aborted Executions
An aborted row is a clue, not a verdict. Here is how to read Query Store execution types and match them with what the caller saw.
Finding the Worst Query in Five Minutes With Query Store
Find the worst query with Query Store totals, compare CPU and duration over the last day, inspect plans, and choose the first tuning target.
Optimized Plan Forcing: Cutting Compile Time in SQL Server 2022
Check optimized plan forcing in SQL Server 2022 through scoped configuration and Query Store replay flags, then compare compile duration.
Query Store Quiz: Where Is Last Week’s Slow Query?
This Query Store Quiz starts with a slow query from last week and a plan cache that restarted empty. The answer is Query Store, which keeps plans and run times inside the database. A tested T-SQL script finds the query, its plan and its duration.
Caching Query Results in the Application
Caching query results in the application can reduce repeated reads when ownership, expiry, invalidation, and memory cost are clear.
Azure SQL Database for the On-Premises DBA
Azure SQL database for the on-premises DBA changes patching and backups, while leaving query tuning, access, cost, and recovery checks with your team.