Removing Query Hints with Plan Guides
Dear SQL DBA
English - May 18, 2017 13:00 - 29 minutes - 55.8 MB - ★★★★★ - 26 ratingsTechnology Education How To dba databases sqlserver sqlworkbooks Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
Previous Episode: Batch Mode Hacks in SQL Server
Next Episode: Which Queries are Causing my Wait Stats?
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/