Your slow query has a clustered index scan on UploadedImage sending 15,152 rows to a merge join. The fast query does a seek, sending 351 rows to a nested loop join.

Do you have the same indexes on this table? Are stats up to date?

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]