SQL SERVER – List Number Queries Waiting for Memory Grant Pending

(Pinal Dave) I have been recently writing about Memory Grant Feedback a lot and I have received a lot of questions about it. I have been answering each of them personally but some questions are so good that I feel like answering them on the blog will help more people.