Technically, you can go on further with partitioning, possibly filtered indexes (depending on data volume and stats) and of course – SQL Server Broker could do very nice here as well

Why people assume that everyone in the world should have an iPhone?