Optimization Help

All I can see is adding indexes to support the two sort operations, and perhaps adding the column in the key lookup as an include, since there's just one.

If you can send an un-anonmymized plan, we might be able to offer more.

Thanks for the prompt answer, I figured it out, I need to add one column into the index as an INCLUDE. It will help the sort and remove the BML.

http://blog.sqlauthority.com/2009/11/09/sql-server-removing-key-lookup-seek-predicate-predicate-an-interesting-observation-related-to-datatypes/