title: Is there a way to query the time when data was last modified (add/edit/delete) in a SQL Server table?
body: <p>I want to periodically aggregate a column in a table containing large number of rows. I save the aggregate results, so i don't want to perform the expensive aggregate operation unless any data in the table is modified. </p>
  
  <p>I do have a "last modified" column in the table but querying <code>MAX(lastModifiedColumn)</code> seems expensive on a million row table.</p>
  
  <p>I'm also not allowed to use triggers.</p>
  
  <p>Any performance friendly solution for this?</p>