Similar to the previous example, in the event of a memory underestimation, you can force the optimizer to guarantee a minimum memory grant for a query execution using the MIN_GRANT_PERCENT query hint. It also accepts float values between 0.0 and 100.0. Be very careful with this hint, since if you specify 100% as the minimum grant, the whole resource governor memory will be granted to a single query execution. If you specify more memory than is available, the query will simply wait for the memory grant.