Artwork

Content provided by Kendra Little. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Kendra Little or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.
Player FM - Podcast App
Go offline with the Player FM app!

Removing Query Hints with Plan Guides

29:49
 
Share
 

Manage episode 213016174 series 2394085
Content provided by Kendra Little. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Kendra Little or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

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/

  continue reading

81 episodes

Artwork

Removing Query Hints with Plan Guides

Dear SQL DBA

126 subscribers

published

iconShare
 
Manage episode 213016174 series 2394085
Content provided by Kendra Little. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Kendra Little or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

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/

  continue reading

81 episodes

All episodes

×
 
Loading …

Welcome to Player FM!

Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.

 

Quick Reference Guide