Tell SQL Server a query is ad hoc and not to optimize based on it (3 Solutions!!)
Channel: Roel Van de Paar
Date: 2021-08-22

Tell SQL Server a query is ad hoc and not to optimize based on it

Helpful?  Please support me on Patreon: https://www.patreon.com/roelvandepaar

With thanks & praise to God, and with thanks to the many people who have made this project possible! | Content (except music & images) licensed under CC BY-SA https://meta.stackexchange.com/help/licensing | Music: https://www.bensound.com/licensing | Images: https://stocksnap.io/license & others | With thanks to user Paul White (dba.stackexchange.com/users/1192), user ooutwire (dba.stackexchange.com/users/7336), user marc_s (dba.stackexchange.com/users/807), user Kris Gruttemeyer (dba.stackexchange.com/users/25146), user Kin Shah (dba.stackexchange.com/users/8783), user Kevin Kalitowski (dba.stackexchange.com/users/43794), and the Stack Exchange Network (dba.stackexchange.com/questions/112568). Trademarks are property of their respective owners. Disclaimer: All information is provided "AS IS" without warranty of any kind. You are responsible for your own actions. Please contact me if anything is amiss at Roel D.OT VandePaar A.T gmail.com