I changed the memory SQL srver was using from the max (2GB) to 100MB, and the query now takes around 175ms.

Thank you everyone for you suggestions and comments.

First, thank you for taking the time to help me figure this out. I really appreciate your time and effort.

I understand where you're going. You are focusing on optimizing the...

The data has to be the same since I took the production database offline, then copied the MDF and LDF files from the server to my computer, and then put...