title: How to find queries that used most memory for sorts
body: <p>How can I determine which queries used most memory for sorts/joins/etc?
  How can I determine how much memory did one particular query use up?</p>
  
  <p>I was hoping to find something like SET STATISTICS IO ON for an individual query, and a DMV to find out worst offenders, but I could not find any.</p>