sam 55243 (11/26/2015)
If I do that in case will it prevent this issue from occurring.
Maybe. And maybe it'll make things worse.
Does the Recompile hint add an unacceptable CPU overhead to your production server?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability