I usually try to change my PK to nonclustered if I know that there are no reads against it. Then I can use my available clustered index on something...

Thanks for the reply Lutz, It helped get me down the right path. Here is what I did:

1) created a user defined function that accepts an input field and...