Performance Surprises and Assumptions : Arbitrary TOP 1

I discuss a case where assumptions can lead to a poorly-performing query and where exploring other options can pay off.