• You could look at creating asynchronous triggers with service broker. This would stop the summary table from interfering with production DB.

    The downside is the plumbing and having to monitor service broker.