Add the ability to add query hints to simple queries/aggregates

By Justin James on 7 May 2015
We'd like to be able to add query hints to simple queries/aggregates without needing to use an advanced query. We have a lot of queries that we need a bit more control over. At the very least, let us select from a list like "optimize for unknown" and "option recompile".

J.Ja
Paulo Ferreira7 May 2015
What would you expect those particular options to do?

Cheers,
Paulo
Justin James7 May 2015
Paulo -

In multi-tenant applications, the execution plans created by SQL Server work well for some tenants but not for others. Depending on the data in the DB, this can cause the SQL Server to go out of control.

J.Ja
Paulo Ferreira11 May 2015
Hi Justin,

Thanks, I understand the use case now. So both options you suggested refer to that same hint, correct?

Cheers,
Paulo
Justin James11 May 2015
Paulo -

They are different ways to control the behavior of execution plans. I don't know they exact details, that came from our DBA. :D

J.Ja