Using a “Goal Posts” Table to Reduce Scan Impact

Logging tables can grow unchecked for years, and date range queries against them get more and more expensive if they don't use the clustered index. Read about one way I've mitigated this problem.