Thanks Celko.

By using MAX() instead of TOP 1, the query execution time got reduced a lot. I do not know if this is because some things are already cached or...