You're absolutely right. In the big scheme of things this means diddly. However, the PartnerID appears on reports, etc. and the customer doesn't like it. I...

Thanks for the reply.

I understand that transaction rollbacks will consume identity values, but there are no processes that are doing bulk inserts. And there are no transactions in any...

Actually, reconsidering my original thought, why wouldn't the second condition (@EmployeeID = 234, for example) result in an index Seek instead of a Scan?