title: How Can I Log and Find the Most Expensive Queries?
body: <p>The activity monitor in sql2k8 allows us to see the most expensive queries. Ok, that's cool, but is there a way I can log this info or get this info via query analyser? I don't really want to have the Sql Management console open and me looking at the activity monitor dashboard.</p>
  
  <p>I want to figure out which queries are poorly written/schema is poorly designed, etc.</p>
  
  <p>Thanks heaps for any help!</p>