Nice post.

Is there a way to determine memory granted to query just before execution and the actual memory it used during runtime. Can we get this information from execution plans.