We have the same situtation with a large reporting database and we have a large subscription service that typically sends out large data files to user. This happens for two...

Anthony Molinaro wrote a book called SQL Cookbook that serves as my right brain, or is it my left brain, for problems just like this.

His example, a scalar subquery, of...