Listen "Removing Query Hints with Plan Guides"
Episode Synopsis
If you need to add, remove, or replace hints from ad-hoc queries and you can't change the code, plan guides can help. See a demo of removing hints from parameterized TSQL run from an application, and get tips on how to make your plan guides work in SQL Server. Get code samples from this episode here: https://sqlworkbooks.com/2017/05/removing-query-hints-with-plan-guides-dear-sql-dba-episode-43/
More episodes of the podcast Dear SQL DBA
Jer and Kendar Explore Optimized Locking
04/09/2023
Erik Darling on Performance Tuning
21/08/2023
Data Roles: DBA, DBRE, and Data Engineer
04/08/2023
ZARZA We are Zarza, the prestigious firm behind major projects in information technology.