I expected it to perform the join inside a sub-select and then select from the result set as a single set of values. That would have helped explain why it...

I'm not sure, I haven't worked with Entity Framework much. What does it do when it has to do a JOIN between two tables?

I'll bet the execution plan for both is the same.

It's a messy way to write procedures, at least for really simple things like this, but it's not going to add...

That gave me a really good laugh first thing this morning. I think that's a pretty...

Ah, I didn't go back and look at the execution plan again.

Hey Jack,

Yeah, OPTIMIZE FOR is actually more than a little big dangerous. What happens when the underlying statistics change? You have to constantly review the work you did with it.

I...

WITH RECOMPILE was never a...

You can also use the OPTIMIZE FOR query hint as a way to force the plan down an optimal path.

Or Jack.

Or you for that matter.

I might though.

After migrating it's pretty strongly suggested that you update statistics with a full scan on all the tables in a database. Did you do this?

I think Barry's right. It's probably parameter sniffing.

Compare both execution plans. See what's different between the two.

Why do you need it to be in a single statement?

That's pretty cool. Gave me a laugh.

Just a suggestion on the original question, you might take a look at Red Gate's SQL Compare. It's not...

Monitoring stored procedures is best done by running what is called a server side trace. You can use the tool "Profiler" to define the trace and then script it out...

Keep hacking away at it, you'll arrive at something useful. In the mean time, you might want to pick up a book on database design. The one I like is...