What is the underlying table clustered on? If it's clus on identity, you should seriously consider clustering instead by date first, esp. if you (almost) always look up by date, rather than ident. You can add the ident to the end of the clus key to guarantee a unique key.
That will reduce the time as much as possible across all queries when coming specifying a date.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".