Dear SQL DBA

Removing Query Hints with Plan Guides

05.18.2017 - By Kendra LittlePlay

Download our free app to listen on your phone

Download on the App StoreGet it on Google Play

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 from Dear SQL DBA